Did you know that if you frequently work with the same multiple workbooks in Excel, you can actually save these into one workspace file? Then you will only have to open one file (rather than trying to find and open several workbook files) in order to have quick access to all of your Excel data.
Here are a few suggestions on how to do this:
- Open all of the workbooks that you use at the same time, and arrange them the way you want by clicking Arrange All on the View tab; then choose Tiled, Horizontal, Vertical, or Cascade.
- To save the file as a workspace file, on the View tab, click the Save Workspace button, and you will be given an opportunity to choose a location.
- Click Save. The file will be saved with the extension .xlw.
- To open the file, navigate to the folder where it is saved, choose the *.xlw file and click Open just like you would any other file. All of the documents will open and be displayed in the same manner as when you saved and closed them. The workspace file will also appear under Recent Workbooks located under the File tab with your other recently saved workbooks.
This workspace file is just a handy way to open multiple workbooks all at once in the same way that you closed them. Everything else works the same. The changes you save to any workbook individually will always appear within the workspace file. If you make any changes to a workbook in the workspace file itself, you will be prompted to save that workbook before closing it.