Shortcut Key

[TJ]

Hey Guys, I'm often working in large sheets and need to bounce up and down
in columns. Is there a shortcut key that will take me to the top of the
current column?

 

[dvt]

Hey Guys, I'm often working in large sheets and need to bounce up and
down in columns. Is there a shortcut key that will take me to the
top of the current column?

Ctl-up arrow and ctl-down arrow might help, assuming you have no empty cells
in the column...

Dave

 

[David McRitchie]

Ctrl+Up and Ctrl+Down do not take you up to the top of the
column and botton of the used data in that column if there are
empty cells in between.

You can use a macro, and I include some icons when I
use it. See

Toolbars, Custom Buttons and Menus
http://www.mvps.org/dmcritchie/excel/toolbars.htm
look for macros GoToTopOfColumn and GoToBottomOfColumn
instructikons to install macros on my getstarted.htm
but be sure to look at the referenced page above.

The macros themselves are:

Sub GotoTopOfCurrentColumn()
Cells(1, ActiveCell.Column).Select 'J.Campion 2000-03-20
End Sub

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