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

Building client loyalty with payroll services

In this report, CPA experts detail their tactics for performing successful payroll services, how to mitigate risk in the process, and the impact payroll can have as a value-added service.

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.