highlight from top to bottom of spreadsheet without scrolling?
Select the top cell. Hold SHIFT and press CTRL+the downward arrow
Or, to select a whole block, including neighbouring populated columns (if
any):
CTRL+SHIFT+*
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"CMMag" wrote in message
...
I am trying to highlight or go to the last line that I have entered
information on an excel spreadsheet. would like to know if there is a
shortcut to do this with out using the scroll bar to get to the bottom?
Example- I want to highlight row 6 through the last row that I have info
entered (316)
|