Selecting Cells, Rows, and Columns


Selecting Cells , Rows, and Columns

To select a range of cells with the mouse, you simply click and drag. (To select a single cell, simply click it.) Alternatively, click to select the first cell , hold down [Shift] , and then click the last cell to select the range in between. You can also select cells, rows, and columns with the keyboard by using the following keyboard shortcuts.

Shortcuts for Selecting Cells, Rows, and Columns

Extend the selection in the direction of the arrow key

[Shift] - [ ] , [Shift] - [ ] , [Shift] - [ ] , [Shift] - [ ]

Hold down [Shift] and use the arrow keys to extend the selection by as many rows and columns as necessary.

Select the current column

[Ctrl] - [Spacebar]

Select the current row

[Shift] - [Spacebar]

Select all cells on the current worksheet

[Ctrl] - [A]

Reduce the selection to the active cell

[Shift] - [Backspace]

If the active cell is off the screen, Excel scrolls the window so that the active cell is displayed. If multiple cells are selected, Excel reduces the selection to the active cell and scrolls the window so that the active cell is displayed.

Select all the objects on the current worksheet while retaining the current selection

[Ctrl] - [Shift] - [Spacebar]

Toggle Extend mode on and off

[F8]

Press [F8] to turn on Extend mode, and then use the arrow keys and other navigation keys without [Shift] to select a range. Excel displays EXT on the status bar when Extend mode is on. Press [F8] again to turn off Extend mode.

Toggle Add mode on and off

[Shift] - [F8]

Turn on Add mode so that you can add another range of cells to the existing selection. Press [Shift] - [F8] , and then use the arrow keys and other navigation keys without [Shift] to select each further range as necessary. Excel displays ADD on the status bar when Add mode is on. Press [Shift] - [F8] again to turn off Add mode.

Extend the selection to the first or last cell in the data area

[Ctrl] - [Shift] - [ ] , [Ctrl] - [Shift] - [ ] , [Ctrl] - [Shift] - [ ] , [Ctrl] - [Shift] - [ ]

The data area is a block of cells containing entries. The end of the data area is defined by a blank column at the left or right, and by a blank row at the top or bottom. Pressing [Ctrl] - [Shift] - and [Ctrl] - [Shift] - in this shortcut extends the selection to the first or last row in the data area. Pressing [Ctrl] - [Shift] - 1 and [Ctrl] - [Shift] - extends the selection to the first or last column in the data area. For example, press [Ctrl] - [Shift] - to extend the selection to the last column used in the data area for the row containing the active cell.

Extend the selection to the first cell in the row

[Shift] - [Home]

Extend the selection to the first cell in the worksheet

[Ctrl] - [Shift] - [Home]

Extend the selection to the last cell used on the worksheet

[Ctrl] - [Shift] - [End]

The last cell used is the last cell that has ever contained an entry. It may not currently contain an entry.

Extend the selection to the last cell with contents in the active column or row

[End] , then [Shift] - [ ] , [Shift] - [ ] , [Shift] - [ ] , [Shift] - [ ]

Extend the selection to the last cell with contents on the worksheet

[End] , then [Shift] - [Home]

Extend the selection to the last cell in the active row

[End] , then [Shift] - [Enter]

Extend the selection downward by one screen

[Shift] - [PageDown]

Extend the selection upward by one screen

[Shift] - [PageUp]

Extend the selection to the first cell in the window

[ScrollLock] , then [Shift] - [Home]

Depending on your keyboard, you may need to press [ScrollLock] again to switch it off after using this keyboard shortcut and the next .

Extend the selection to the last cell in the window

[ScrollLock] , then [Shift] - [End]




Windows XP and Office 2003 Keyboard Shortcuts
Windows XP and Office 2003 Keyboard Shortcuts
ISBN: 0072255005
EAN: 2147483647
Year: 2003
Pages: 117

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net