If the same set of workbooks are used frequently, they could be saved as a workspace file, saving time opening and arranging them in future.
A workspace file saves all the information about the open workbooks including their screen posiition and window size.
When the workspace is opened, it opens each workbook saved in the workspace and displays them on screen as it was saved. Workbooks that are saved in a workspace file can still be opened and worked on individually.
Before creating a workspace, lets arrange the workbooks on screen so that they are easier to work with.
Excel provides 4 different window arrangement options for working with multiple workbooks. They are Tiled, Horizontal, Vertical and Cascade.
To apply one of these views, click Arrange under the Window menu and select the option you require.
As we are using 3 workbooks, we have decided upon the tiled arrangement.
Creating a workspace file
- Click File > Save Workspace
- Navigate to the file location that you want to save the workspace
- Enter a name for the workspace file in the File name field
- Click Save
The Save Workspace dialogue box is displayed
Opening a workspace file
- Click File > Open
- Navigate to the location of the workspace file
- Select the workspace
- Click Open
The Open dialogue box is displayed
Each workbook saved within the workspace will be opened and positioned on screen.