Keyboard shortcut or selecting entire column
 

Which one is the ks for selecting all the cells in a column up to the last
used cell including blank cells in between?

Thanks

Keyboard shortcut or selecting entire column
 

I always use Ctrl+left shift + down arrow


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562501

Keyboard shortcut or selecting entire column
 

There isn't one AFAIK

I use a macro assigned to a button.

Sub GODOWN()
Dim maxrow As Long
With ActiveCell.Parent.UsedRange
maxrow = .Cells(.Cells.Count).Row + 1
End With
ActiveCell.Parent.Cells(maxrow, ActiveCell.Column).End(xlUp).Select
End Sub


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 08:23:02 -0700, Precious_Stone
wrote:

Which one is the ks for selecting all the cells in a column up to the last
used cell including blank cells in between?

Thanks