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

6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.