View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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 :-)