Save workbooks in an arranged workspace

You can save a snapshot of the current layout of all open and arranged workbook windows in a workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.) (.xlw). When you open a workspace file, Microsoft Office Excel opens all workbooks and displays them in the layout that you saved.

  1. Open the workbooks that you want to save in a workspace.
  2. Arrange the workbook windows as you want them to appear when you open the workspace, changing the size of each workbook window as needed.
  3. On the View tab, in the Window group, click Save Workspace.

Excel Ribbon Image

  1. In the File name box, type a name for the workspace file.

 Note   The default name is resume.xlw, but you can rename it.

 Tip   To open the workbooks that you saved in the workspace file each time that you start Excel, you can save that workspace file in the XLStart folder. Save only the workspace file, not the workbook files, in the XLStart folder. In Windows Vista, the path to the XLStart folder is C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart folder. In Microsoft Windows XP, the path to the XLStart folder is C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart folder.

Applies to:
Excel 2007