Shortcut Key

  • Thread starter Thread starter TJ
  • Start date Start date
T

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?
 
TJ said:
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?
Click to expand...

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

Dave
 
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
 
Back
Top