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 QUIZ

How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.

SPONSORED REPORT

In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.