Microsoft Excel training

Working with multiple workbooks in Excel

If you regularly work with many workbooks at the same time, you can save time by creating an Excel Workspace.

Proceed as follows:

  1. Open the Excel workbooks that you want to save in a workspace.
  2. Arrange the Workbook windows as you want them to appear when you open the Excel Workspace, changing the size of each Workbook window as needed.
  3. On the View manu, in the Window group, click Save Workspace.
  4. Save the Excel Workspace as you would a regular Excel Workbook. When you open the Workspace, all Excel Workbooks will be in the same ordering and size as they were when you saved the Workspace.


   
workbooks, multiple, excel