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

2018 financial reporting survey: Challenges and trends

Learn the top reporting challenges that emerged in a survey of more than 800 finance, accounting, and compliance professionals across the world, and compare them with your organization's obstacles.

PODCAST

How the skill set for today’s CFO is changing

Scott Simmons, a search expert for large-company CFOs, gives advice for the next generation of finance leaders and more, including which universities are regularly producing future CEOs and CFOs.