Home In On A Target Worksheet

BY STANLEY ZAROWIN

Q. I have loads of worksheets in a single Excel file—so many, in fact, that the identification tabs extend off the screen. As a result, finding the one I want and switching to it is like a game of chance. Any tips?

A. There’s a quick and easy way to find your targeted worksheet. Look at the bottom left of your Excel screen. There are four arrows (they’re called navigation buttons ). Two of them point to the left and two point to the right. Right-clicking on any of the arrows will bring up a Context menu that lists all the worksheets in that file. Pick the one you want and click on it. Presto! No need even to figure out which way to navigate to locate the worksheet you want.

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.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

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.