Microsoft Office Tutorials and References
In Depth Information
Getting a Better Look at the Worksheet
The Go To command: On the Home tab, click the Find & Select button
and choose Go To on the drop-down list (or press Ctrl+G or F5). You see
the Go To dialog box. Enter a cell address in the Reference box and click
OK. Cell addresses you’ve already visited with the Go To command are
already listed in the dialog box. Click the Special button to open the Go
To Special dialog box and visit a formula, comment, or other esoteric
The Find command: On the Home tab, click the Find & Select button and
choose Find on the drop-down list (or press Ctrl+F). Enter the data you
seek in the Find What box and click the Find Next button. Click the Find
All button to find all instances of the item you’re looking for. A list of the
items appears at the bottom of the dialog box; click an item to go to it.
To scroll to the active cell if you no longer see it on-screen, press Ctrl+Backspace.
Getting a Better Look at the Worksheet
Especially when you’re entering data, it pays to get a good look at the
worksheet. You need to know which column and row you’re entering data in.
These pages explain techniques for changing your view of a worksheet so
that you always know where you are. Read on to discover how to freeze,
split, and hide columns and rows. (On the subject of changing views, Book I,
Chapter 3 explains an essential technique for changing views: zooming in
and zooming out.)
Book III
Chapter 2
Freezing and splitting columns and rows
Sometimes your adventures in a worksheet take you to a faraway cell
address, such as X31 or C39. Out there in the wilderness, it’s hard to tell
where to enter data because you can’t see the data labels in the first column
or first row that tell you where to enter data on the worksheet.
To see one part of a worksheet no matter how far you stray from it, you can
split the worksheet or freeze columns and rows on-screen. In Figure 2-1, I
split the worksheet so that column A (Property) always appears on-screen,
no matter how far I scroll to the right; similarly, row 1 (Property, Rent,
Management Fees, and so on) also appears at the top of the worksheet no
matter how far I scroll down. Notice how the row numbers and column
letters are interrupted in Figure 2-1. Because I split the screen, I always know
what data to enter in a cell because I can clearly see property names in the
first column and the column headings along the top of the worksheet.
Search JabSto ::

Custom Search