1. Home
  2. MS Office

Save Excel 2010 Workbook Window Layout As Workspace

Excel 2010 allows user to save workbook workspace to restore the layout of  Excel window anytime in future. It can be helpful in situations when you are dealing with multiple worksheets for comparison purposes or when you need to remember the layout of  each opened window.

For saving the spreadsheet layout, navigate to View tab and click Save Workspace.

766d1277112721-save-excel-workbook-window-workspace-

This will open Save Workspace dialog, now specify workspace name and click save. Now when you open it again, it will restore the worksheet window layout.

765d1277112720-save-excel-workbook-window-workspace-

6 Comments

  1. I just started using EXCEL 2010 in a new contract job. I spotted the “Save Workspace” button in the ribbon when I was futzing with four spreadsheets at once. I saved the workspace I’d created and I was impressed with how fast the workspace was re-loaded. I wanted to learn more so I could share this feature with several friends who are also using Office 2010 for the first time. The Help gave me a link that led me here. Thanks for the instructions.

  2. Ha! There it was all the time. Deja Gnu! Now I can’t not see it. Thanks!
    Also, if you Restore all the open sheets and right-click on empty space, you get the opportunity to save the workspace there, too.

  3. VERY useful!!! I had been playing around with excel and also looked it up in the helpsection with no success..

    Love it!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.