Excel keystrokes that enable you to move through a worksheet

1. Up arrow –> Moves the active cell one row up
2. Down arrow  –> Moves the active cell one row down
3. Left arrow  –> Moves the active cell one column to the left
4. Right arrow  –> Moves the active cell one column to the right
5. PgUp  –> Moves the active cell one screen up
6. PgDn –> Moves the active cell one screen down
7. Alt+PgDn  –> Moves the active cell one screen right
8. Alt+PgUp  –> Moves the active cell one screen left
9. Home  –> Moves the active cell to the first column of the row that the active cell is currently in
10. Ctrl+Home  –> Moves the active cell to the beginning of worksheet (A1)
11. F5  –> Displays the Go To dialog box
12. Ctrl+Backspace  –> Scrolls the screen to display the active cell
13. Up arrow*  –> Scrolls the screen one row up (active cell doesn’t change)
14. Down arrow*  –> Scrolls the screen one row down (active cell doesn’t change)
15. Left arrow*  –> Scrolls the screen one column left (active cell doesn’t change)
16. Right arrow*  –> Scrolls the screen one column right (active cell doesn’t change)

Excel : Changing a Worksheet’s Name

By default, Excel names its worksheets Sheet1, Sheet2, and so on. Providing more meaningful names helps you identify a particular sheet. To change a sheet’s name:

1. Double-click the sheet tab, or right-click the sheet tab and choose Rename from the menu that appears. Either method selects the text in the tab.
2. Type the new sheet name directly on the tab.