Save time by creating an Excel workbook workspace


If you’re like most of us, you probably work with the same few workbooks every day. You might work with them as a group or separately, but you open these files, individually, most every day and that’s inefficient.

You can save a bit of time by saving the files you use every day as a group as follows:

  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 group (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 reduce a few keystrokes every day.

Advertisements

3 thoughts on “Save time by creating an Excel workbook workspace

thanks 4 u comments..

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s