Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut to move to top of column in worksheet? | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions |