Excel shortcut for highlighting data

**drreamsurfer** · 05-17-2007, 07:54 AM

Hi

Is there a shortcut in excel for the following?

I am highlighting rows is there any button that you can press so that excel automatically finds the last row on the spreadsheet instead of dragging cells all the way down to the end??

Help much appreciated!

L

**sweep** · 05-17-2007, 07:57 AM

Select the 1st cell. Hold shift, and tap "END" then the "cursor down" key.

**drreamsurfer** · 05-17-2007, 08:11 AM

perfect thanks

**Simon Lloyd** · 05-17-2007, 08:32 AM

Sweep that works for a single column but to select a whole range Ctrl+Shift+End

To find last used cell in current column Ctrl+CursorDown hit Cursor Down again for next available cell.