Two other variations-

Click in name box and type range if you know it (eg., C7:AJ99), press Enter,
or
Click start of range (C7), use scroll bar to show end of range (AJ99) &
Shift-Click it.

Also, if you need to select the same range frequently, select it & go to
InsertNameDefine. Give it a name of your choice & then use the Name List to
select it whenever necessary, (ShortCut- select the range, click the
reference that appears in the Name List, type a name & press Enter... does
the same thing).

HTH |:)

"Pat" wrote:

How do you stop the sheet from moving quickly when selecting a large number
of cell. I find it is difficult to select a range as the sheet moves beyond
the range required.

I did not see anything in Tools/Options that could help.

Pat