Last active cell in column

[Dsuperc]

Hi,
Is there a short cut key to select all active cells in a column including blank cells within the range?

 

[Mark W.]

There is only 1 active cell -- the single cell with the bold border or the single cell with the light background among several selected cells.
This message was edited by Mark W. on 2002-10-15 15:52

 

[Dsuperc]

Ok, Let me put it another way.
I have a spread sheet consisting of 6 colums and approx 5000 rows.
In column A I want to select all the cells from A1 to the last cell with data, includung blank cells.
Is there a short cut key for this operation?

 

[Mark W.]

Press and Hold the Shift key prior to double-clicking on the Edit | Go To... [ Special... ] Last cell radio button.

 

[paliman]

Click on the column header to select the whole column. Then hold Ctrl+Shift and press the Up arrow to go to the last cell with data.

 

[SamS]

On 2002-10-15 16:12, Mark W. wrote:
Press and Hold the Shift key prior to double-clicking on the Edit | Go To... [ Special... ] Last cell radio button.

Mark, I tried this and found that the range hilited was the entire data range ie in my case A1:F63 where as Pali's ctrl+shift +up arrow works a treat

 

[rikrak]

Or...

insert this code:
<pre>
Sub sel()
'CONTROL + s
col = ActiveCell.Column
Range(Cells(1, col), Cells(65536, col).End(xlUp)).Select
End Sub
</pre>

- Hit ALT+F8 to open the macro dialog
- select the macro
- select the options button
- assign hotkey (CONTROL + s in this example)

-Select a cell somewere in the column of your example
-use CONTROL + s to select

 

[Mark W.]

On 2002-10-15 17:04, SamS wrote:

On 2002-10-15 16:12, Mark W. wrote:
Press and Hold the Shift key prior to double-clicking on the Edit | Go To... [ Special... ] Last cell radio button.

Mark, I tried this and found that the range hilited was the entire data range ie in my case A1:F63...

Yes, I believe that was the intent of the OP....

I have a spread sheet consisting of 6 colums and approx 5000 rows.
In column A I want to select all the cells from A1 to the last cell with data, including blank cells...

 

[SamS]

OK - I read it as selecting data only in column A. I am happy though as I learn't 2 new things from this post that I wasn't aware of before.

 

[rikrak]

<quote>
Yes, I believe that was the intent of the OP....
</quote>
I think you are right about that.

<quote>
Press and Hold the Shift key prior to double-clicking on the Edit | Go To... [ Special... ] Last cell radio button.
</quote>

Do you call this a shortcut?

I'll stick to my (modified) macro that can be started with shortcut control+s:
<pre>
Sub sel()
' CTRL+s
Range("A1", Range("A1").SpecialCells(xlCellTypeLastCell)).Select
End Sub
</pre>