HIGHLIGHTING A COLUMN OF DATA

[Guest]

I HAVE DATA IN A COLUMN, SAY IN A1 THROUGH A300.

I also have a "name" for the last cell, A300, call it "END".

Question: How do I highlight the entire column...cells A1 through A300
without having to drag the mouse...so that I can copy and paste it to another
column (for sorting in numerical order)??

Thanks.,

FLKulchar

 

[Guest]

click on the first cell and then touch
SHIFT-END
SHIFT-down arrow

 

[Guest]

Thank you!!!!!!!!!!!!!!!!!!!!!!!!

click on the first cell and then touch
SHIFT-END
SHIFT-down arrow

 

[Don Guillett]

Range("a1:" & Range("end").Address).copy range("b1")