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