#256 Save Time With Excel Workspaces

Are you one of those people who regularly work in the same set of Excel spreadsheets? Would you like to save some time and open them all at once with the same display settings, etc? If so, you might want to save them as an Excel workspace.

A workspace is a file that saves display information about open workbooks, so that you can come back later and pick up just as you left off with the same window sizes, print areas, screen magnification, and display settings.

When using a workspace you only need to open the one workspace file instead of each spreadsheet separately then repeatedly configuring each one to your liking.

How It Works

Excel 2003

  1. Open the workbooks you want to save in a workspace.
  2. Size and arrange the workbook windows as you want them to appear when you open the workspace.
  3. On the File menu, click Save Workspace.
  4. In the File name box, type a name for the workspace file.

Excel 2010

  1. Open all the workbooks you want to save as a group.
  2. Click the View tab.
  3. Click Save Workspace in the Window group.
  4. Enter a name for the group, and click Save.

To open the workspace (and all the workbooks in the group), open the group as you would any other file.

Your workbooks are still separate files. You can open and close them individually, as you normally would. However, Excel also saves a reference to the workbooks as a group now, using the .xlw extension. It’s a simple way to work a little more efficiently everyday.


One thought on “#256 Save Time With Excel Workspaces

  1. Robin Hellalat says:

    This is an excellent timesaving and convenient tip. It is nice not to have to open several excel sheets and still get the job done. Thanks!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s