Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight from top to bottom of spreadsheet without scrolling?
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) |
#2
|
|||
|
|||
Answer: highlight from top to bottom of spreadsheet without scrolling?
Shortcut to Highlight a Range in Excel
Yes, there is a shortcut to highlight from the top to the bottom of a spreadsheet without scrolling. Here are the steps:
Alternatively, you can use the keyboard shortcut Code:
Ctrl + Shift + End
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight from top to bottom of spreadsheet without scrolling?
Assuming contiguous data...
click in the column that you are trying to find end of data, in row 6, then press CTRL+down arrorw to go to the last row of data, or SHIFT+CTRL+down arrow to select from row 6 to last row of data. -- John C "CMMag" wrote: 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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight from top to bottom of spreadsheet without scrolling?
CTRL-End will take you directly to the cell that Excel thinks is the
last used cell, so to do what you want: highlight row 6 by clicking on the row identifier; hold down the SHIFT key; press CTRL-End; release the SHIFT key. Hope this helps. Pete On Oct 14, 5:00*pm, CMMag wrote: 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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight from top to bottom of spreadsheet without scrolling?
to higlight top to bottom, press Ctrl G the type B:B (or the column u want to
highlight) to go down quick press Ctrl and Down-Arrow (may need to hit more than once, if you have marged cells) "CMMag" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight a complete row when scrolling | Excel Discussion (Misc queries) | |||
summation to show at the bottom when I highlight selected cells? | Excel Worksheet Functions | |||
When i highlight cells, I USED to get total in bottom rt corner? | Excel Worksheet Functions | |||
What keys to move from bottom to top of page without scrolling? | New Users to Excel | |||
Excel 2002 is scrolling to the very bottom of my spreadsheet | Excel Discussion (Misc queries) |