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

2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.