how do i mark range from A1 to DV5000 without scrolling?

C

cricketunes

Hi
Is there a menu option to mark a range from A1 to some far off cell
like DK4563 without scrolling all the way down and across?

thanks
Cricket :)
 
C

Chip Pearson

You can type the address, e.g., A1:DK4563, in the Name Box, which
is to the left of the formula bar. This will select the specified
range.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
R

Ron Coderre

Try this:

Press [F5]...(shortcut for Edit>Goto)
Reference: Enter A1:DK4563
Press [OK]

Is that what you meant?

***********
Regards,
Ron
 
N

Norman Jones

Hi Cricket,

Try typing A1:DK4563 in the names box (above the A column header) and then
hit enter.

Or. instead of the names box use the GoTo dialog (F5)
 
Top