Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can save a snapshot of the current layout of all open and arranged workbook windows in a workspace file (.xlw). When you open a workspace file, Excel opens all workbooks and displays them in the layout that you saved.

Note: The Save Workspace command is not available in Excel 2013 and later. However, you can still open a workspace file (*.xlw) that was created in an earlier version of Excel. To view multiple windows in Excel 2013 or later, open the workbooks you want to show, or create new windows (View > New Window), and then arrange them the way you want (View > Arrange All).

  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.

    The Window group on the View tab

  4. 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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×