I have the problem that when i want to highlight a column of data, (bu
the data does not start at the top of the column) i have to highligh
down over 7000 cells.

Generally i end up scrolling to about row 10 000, then wizz past th
other way up to a bout 5000, gradually getting closer to the 7000 mark
but taking ages to actually get there!

Is there a way i can set the bottom of the spreadsheet or something?

cheers for any help!!
-Su

--
Message posted from http://www.ExcelForum.com

Select the "top" cell, then hold the shift key down. Press end, then the
down arrow cursor key and your column will be selected to the bottom of
the column.

In article <(E-Mail Removed)>,
tsumanii <<(E-Mail Removed)>> wrote:

> I have the problem that when i want to highlight a column of data, (but
> the data does not start at the top of the column) i have to highlight
> down over 7000 cells.
>
> Generally i end up scrolling to about row 10 000, then wizz past the
> other way up to a bout 5000, gradually getting closer to the 7000 mark,
> but taking ages to actually get there!
>
> Is there a way i can set the bottom of the spreadsheet or something?

Assuming there are no blank cells in the column.

If blanks exist, keep the SHIFT key depressed and keep hitting END + Downarrow
until you reach the bottom.

I prefer this macro attached to a button on my Toolbar.

Sub select_alldown()
'from selected cells in selected columns to bottom
'of longest used range in columns including blanks
Range(Selection, Cells(Rows.Count, Selection.Column).End(xlUp)).Select
End Sub

Gord Dibben Excel MVP

On Fri, 06 Feb 2004 05:28:02 -0700, JE McGimpsey <(E-Mail Removed)> wrote:

>Select the "top" cell, then hold the shift key down. Press end, then the
>down arrow cursor key and your column will be selected to the bottom of
>the column.
>
>In article <(E-Mail Removed)>,
> tsumanii <<(E-Mail Removed)>> wrote:
>
>> I have the problem that when i want to highlight a column of data, (but
>> the data does not start at the top of the column) i have to highlight
>> down over 7000 cells.
>>
>> Generally i end up scrolling to about row 10 000, then wizz past the
>> other way up to a bout 5000, gradually getting closer to the 7000 mark,
>> but taking ages to actually get there!
>>
>> Is there a way i can set the bottom of the spreadsheet or something?