Can I stop scrolling at a certain row?

  • Thread starter Thread starter tsumanii
  • Start date Start date
T

tsumanii

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
 
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.
 
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
 
Back
Top