Keep a neater desktop when mutliple workbooks are open….

If you one of the many Excel users who frequently have two, three, or more workbooks open simultaneously then you know that kind of mess you can have on your screen. Within the Excel window, you can navigate between workbooks by pressing [Ctrl][F6] or by opening the Window menu and selecting a workbook from the list of open files.

Excel offers an option that can help you avoid clutter while keeping as many workbooks open as you like. To try it out, open three or four workbooks, and go to "Window" on the menu bar and then click on "Hide". When you do, Excel erases all traces of the current workbook from your screen. The workbook is still open, but you can’t see it. Then you can hide all of them if you wish, yet they’re still open for ready acccess.

To make a hidden workbook visible again, go to Window | Unhide, and you’ll see a list of the hidden workbooks. Select the workbook that you want to work on, and click OK.

Don’t worry about forgetting that you have a workbook open. If you close Excel while a workbook is hidden and you haven’t saved your changes, Excel asks if you want to save the changes to any unsaved workbooks.

Hope this little tip comes in handy for you.

That’s my two bytes…Dennis

Advertisements