• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > Extend a Selection

Extend a Selection

PressTo
F8Turn on or off extend mode. In extend mode, EXT appears in the status line, and the Arrow keys extend the selection.
Shift+F8Add another range of cells to the selection, or use the arrow keys to move to the start of the range you want to add, and then press F8 and the Arrow keys to select the next range.
Shift+Arrowkey Extend the selection by one cell.
Ctrl+Shift+Arrowkey Extend the selection to the last nonblank cell in the same column or row as the active cell.
Shift+HomeExtend the selection to the beginning of the row.
Ctrl+Shift+HomeExtend the selection to the beginning of the worksheet.
Ctrl+Shift+EndExtend the selection to the last used cell on the worksheet (lower-right corner).
Shift+PageDown Extend the selection down one screen.
Shift+PageUp Extend the selection up one screen.
End, Shift+Arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell.
End, Shift+HomeExtend the selection to the last used cell on the worksheet (lower-right corner).
End, Shift+EnterExtend the selection to the last cell in the current row. This key sequence does not work if you have turned on transition navigation keys (Tools menu, Options command, Transition tab).
Scroll Lock+ Shift+HomeExtend the selection to the cell in the upper-left corner of the window.
Scroll Lock+Shift+EndExtend the selection to the cell in the lower-right corner of the window.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint