Microsoft Office Tutorials and References
In Depth Information
Create a Workspace of Workbooks
Chapter 2: Making It Easier to Manage Workbooks
Open a Workspace
1 Click the File tab.
2 Click Open.
The Open dialog box
3 Click here and select
4 Click the workspace file
you want to open.
5 Click Open.
Excel opens each
workbook that is part of
Did You Know?
You do not need to restrict yourself to a
single workspace file. For example, you
could create a separate workspace file
for each project you are currently
working on. This enables you to quickly
switch from one set of workbooks to
another, or even open multiple
workspaces at the same time.
When you open a workspace or switch from
one workspace to another, you usually want
to close all the open workbooks to avoid
cluttering the Excel window. Rather than close
each workbook manually, customize the Quick
Access Toolbar or the Ribbon with the Close
All command, which closes all open files. See
Chapter 1 to learn how to customize these