Saving a Workspace

If you have opened several windows to create a view of your worksheet you can save the workspace.  Click on the File drop-down menu and choose Save Workspace, enter a meaningful name for your workspace (you can create other arrangements of the same sheets and save them as different workspaces) and click Save.  When you open a new Excel file you can choose to either open a single workbook or a workspace which will display several items at once.

The workspace does not actually contain the data from your spreadsheets, just the layout information.  You must still save the individual files to store the data contained therein.  If you close your workspace and are asked if you want to save changes to one of the component files, make sure you choose Yes.

When you have a workspace open, holding down the CTRL key and pressing F6 or TAB at the same time (CTRL+F6 or CTRL+TAB) will move to the next window, holding down CTRL and SHIFT and F6 or TAB at the same time (CTRL+SHIFT+F6 or CTRL+SHIFT+TAB) will move in the opposite direction.

To close an unwanted window in a workspace, click on the title bar at the top of the window and then click the cross in the top right corner to close it.  You can now re-save your workspace with the new arrangement.

Click here to return to the Excel index.