Datasheet

Navigating in Excel
11
It is important to note that if you click into a cell beyond the data area and just put one
space in that cell, or enter data in that cell and then delete it, Excel will see this as the last
cell that contains data, so Ctrl+End is not always reliable.
6. Click your mouse pointer in cell A3 to make that the active cell. Press Ctrl+→ to move to
cell E3, which is the last cell in that row containing data.
7. Click in the Name box at the top of your screen, below your Formatting toolbar. Type a4 in
this box and press Enter. This capitalizes the A in the Name box and moves you to cell A4.
Note that when you type a cell address in the Name box or in a formula, you don’t have
to capitalize the column identifier. Excel will recognize it as a cell reference and capitalize
the letter(s) for you.
8. Press the End key on your keyboard. Look at the Status bar at the bottom of your screen;
note the word “END” in the lower-right corner. Now press Enter and you will move to the
last cell on that row that contains data. Press End again to remove the word “END” from
your Status bar, if it doesn’t automatically disappear.
9. Press the ↑ , ↓ , ← , and → keys to move from cell to cell.
10. Press the F5 key on your keyboard to bring up the Go To dialog box. Type h77 in the Ref-
erence box and click OK. This takes you to cell H77.
11. Choose Go To from the Edit menu, and it shows you other cells you have recently
selected. Click one of them and click OK to return to that cell.
12. Press Ctrl+Home to return to cell A1. From the Edit menu, choose Find.
13. In the Find What box, type french, and then click the Find Next button. This takes you to
cell A6, where the word “French” is located.
14. Click the Close button to close the Find and Replace dialog box.
15. Press Ctrl+F to open the Find box again. Type 2 in the Find What box. (Note that the word
french is highlighted in black. Typing 2 will replace what is highlighted.) Click Find Next
and you will move to cell C7, which is the next cell that contains the number 2.
16. Click the Find All button and the list displayed at the bottom of the Find box shows you
all the cells on this sheet that contain the number 2. The Value column shows all the val-
ues that include the number 2. Click the one that shows Week 2 and you move to cell C3.
To find all occurrences in the workbook, click the other sheet tabs and click Find All again.
17. Close the Find and Replace dialog box and close the file. Do not save any changes.
EXERCISE 1.3 (continued)
4002book.fm Page 11 Friday, March 24, 2006 11:36 PM