navigation

[Dave B]

If I have a worksheet with a lot of data, if I press Ctrl + down arrow, it
goes all the way to the next empty space, or to the bottom of the data if
there are no blank cells. But I've seen workbooks where it goes to the
bottom of the table of data, even if there are blanks in the table. Is
there a special cell format for navigation that tells Excel to skip over
blank cells in a table when holding down Ctrl? Thanks.

 

[Greg]

Try
Tools-> Options ->
check Transition Navigation Keys

Regards,
Greg

 

[PegL]

Ctrl+end will go to the last used cell in the spreadsheet.

 

[David McRitchie]

Hi Dave,

Sub GotoBottomOfCurrentColumn()
'Tom Ogilvy 2000-06-26
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub

to install the macro see my getstarted.htm page
http://www.mvps.org/dmcritchie/excel/getstarted.htm

to obtain an icon and install on your toolbar see my toolbar.htm page.
http://www.mvps.org/dmcritchie/excel/toolbar.htm#addicon
http://www.mvps.org/dmcritchie/excel/toolbar#xl2kTBM