Two Better Ideas

BY STANLEY ZAROWIN

Ali Allison, CPA, tax practice manager at Singer Lewak LLP in Los Angeles, had some useful ideas about the Tech Q&A item “Generate Duplicate Changes in Multiple Excel Worksheets,” which appeared in the December 2008 issue, page 104. The article is about keeping several similarly laid out spreadsheets along with an annual summary sheet. She suggests adding a “3D” reference for an overview. To do that, she adds, the summary worksheet should have a formula like =SUM(Jan:Dec!B5) to total all the cells in B5 from sheet Jan to sheet Dec. To get the 3D reference, type =SUM in the summary worksheet and then click on the first sheet (for example, Jan), and hold down the Shift key as you click on the last sheet (that is, Dec) and finally click in the cell to be totaled (that is, B5). And presto: an instant 3D reference.

 

And in the same column, regarding the item “A Quick Way to Erase Selected Data From a Workbook,” she points out that our suggestion to use GoTo, Special to identify and remove Constants is not enough. She explains that some accountants use Excel as a calculator and will enter, for example, =25+25+10. Since Excel will read that as a formula, it won’t select it as a constant and remove it. She suggests viewing the formulas with Ctrl-` (the key to the left of the 1 key) to see what’s left after the constants have been erased to see what else needs to be deleted.

 

SPONSORED REPORT

Tax reform changes are now in effect

With all the recent tax law changes, this year it’s more important than ever to make sure your clients’ tax situations are squared away before year end. This report provides necessary guidance to ensure 2019 starts without a hitch.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.