A Better Way


A BETTER WAY
In the January issue (page 82), I suggested an automatic way to open a group of Excel worksheets in just a few steps—a technique that is especially handy when you need to regularly reopen that group in the future. Several readers suggested a much ­better way to perform that task, applying Excel’s Save Workspace function

To use Save Workspace in Excel 2003, first open the files you want in the group and then click on File, Save Workspace (see screenshot below) and give it a name (it will automatically be given a .xlw extension).

If you wish, you can customize the setup before you save the file so that selected worksheets within each file will open, or you can even customize it further by having several sections of worksheets all open and arranged on one screen. To do that, click on Window, New Window and Arrange, which brings up this screen:

You can arrange the worksheet layout in a way that lets you easily access just the data you need, as illustrated in the following screenshot:

Excel 2007 also has the Save Workspace function and, as expected, it’s accessed differently. Open the target files and then go to the Ribbon and click on View to access both New Windows (so you can display more than one worksheet) and Arrange All (to customize the display). The Save Workspace icon is farther to the right.

Since there is no limit to the number of Save Workspace files you can store, you may want to establish one for each client or business category.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.

SPONSORED REPORT

Solving the lease accounting challenge

The challenges of the new lease accounting standard have been pervasive to say the least. In this free, independently-written report, you'll learn effective adoption strategies as well as resources for easing the transition to the new standard.