Excel Worksheet Disappears Minimize
On the view menu click full screen to turn off this feature.
Excel worksheet disappears minimize. This will totally hide the ribbon including all tabs and commands. Follow the steps to do so. In the open dialog box locate the file in which the issue occurs. If the issue occurs in word skip to step 11.
On the view menu point to toolbars and then click customize. The user frequently opens multiple workbooks and switches between them using the windows taskbar however the list of open files is now disappearing from the taskbar when she opens a new one. As a result if you close the workbook after entering some valuable information and then click on no button when the popup displays the message to save the file then ms excel file may be saved without the recently added information and the unsaved data disappears from the spreadsheet. Then resize anyway you want.
Right click on any visible tab on the worksheet click unhide then in the unhide dialog box click sheet you desire to unhide click ok. If you want to just minimize a single workbook you can use the code below credit to this answer on so for the minimizing specific workbooks sub test dim wbname as window set wbname activeworkbook windows 1 you can use windows workbook name as well wbname visible false wbname visible true end sub. Click the ribbon display options icon on the top right corner of the excel window to the left of the minimize icon. So if she has doc1 doc2 open in excel she ll open doc3 and only doc3 will be displayed in the taskbar docs 1 2 are only accessible via alt tab ing.
If you aim to have the largest amount of screen space for a workbook area use the auto hide option to get excel in kind of full screen mode. Window within excel and you make it less than maximized still not.