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

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 :-)

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

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


wrote in message
oups.com...
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 :-)

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

Try this:

Press [F5]...(shortcut for EditGoto)
Reference: Enter A1:DK4563
Press [OK]

Is that what you meant?

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


" wrote:

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 :-)

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

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)


---
Regards,
Norman


wrote in message
oups.com...
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 :-)

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

Bingo, all three of you!

Thanks!!! :-)