Microsoft Office Tutorials and References
In Depth Information
Moving Around in a Worksheet
If nothing happens when you double-click, or if pressing F2 lands the cursor
in the Formula bar, not a cell, somebody has been fooling with the Options
settings. On the File tab, choose Options, select the Advanced category in
the Excel Options dialog box, and click the Allow Editing Directly in Cells
check box.
Moving Around in a Worksheet
Going from place to place gets progressively more difficult as a worksheet
gets larger. Luckily for you, Excel offers keyboard shortcuts for jumping
around. Table 2-1 describes these keyboard shortcuts.
Table 2-1 Keyboard Shortcuts for Getting Around in Worksheets
Press. . .
To Move the Selection. . .
Home
To column A
Ctrl+Home
To cell A1, the first cell in the worksheet
Ctrl+End
To the last cell in the last row with data in it
, , ,
To the next cell
Ctrl+ , , ,
In one direction toward the nearest cell with data in
it or to the first or last cell in the column or row
PgUp or PgDn
Up or down one screen’s worth of rows
Ctrl+PgUp or Ctrl+PgDn
Backward or forward through the workbook, from
worksheet to worksheet
As well as pressing keys, you can use these techniques to get from place to
place in a worksheet:
Scroll bars: Use the vertical and horizontal scroll bars to move to
different areas. Drag the scroll box to cover long distances. To cover long
distances very quickly, hold down the Shift key as you drag the scroll box
on the vertical scroll bar.
Scroll wheel on the mouse: If your mouse is equipped with a scroll
wheel, turn the wheel to quickly scroll up and down.
Name box: Enter a cell address in the Name box and press Enter to go to
the cell. The Name box is found to the left of the Formula bar.
Search JabSto ::




Custom Search