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.

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.