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

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.