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