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, Microsoft Office Excel opens all workbooks and displays them in the layout that you saved.
Open the workbooks that you want to save in a workspace.
Arrange the workbook windows as you want them to appear when you open the workspace, changing the size of each workbook window as needed.
On the View tab, in the Window group, click Save Workspace.
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.