How can i quickly mark a huge range, like A1 to DV3500?
 

Hi folks,
How can i move from A1 to DV3500 quickly without scrolling all the way
down?
What keys will achieve this?
thanks
Cricket

How can i quickly mark a huge range, like A1 to DV3500?
 

Select cell A1, Ctrl+G (goto), type DV350, hit return (or click OK) while
holding down the shift key

wrote in message
ups.com...
Hi folks,
How can i move from A1 to DV3500 quickly without scrolling all the way
down?
What keys will achieve this?
thanks
Cricket

How can i quickly mark a huge range, like A1 to DV3500?
 

Click in A1.
Click in the Name Box (left of formula bar).
Type in
dv3500
Hold down <Shift
Hit <Enter.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


wrote in message
ups.com...
Hi folks,
How can i move from A1 to DV3500 quickly without scrolling all the way
down?
What keys will achieve this?
thanks
Cricket

How can i quickly mark a huge range, like A1 to DV3500?
 

If its the whole document i.e. the start point and the end point, you
can use the keyboard keys

"Control+Home" followed by "Control+Shift+End"


nb Ctrl+Shft+End will take you to the last cell that has data _or_ has
been formatted. So if you have formatted a whole column or
row........................:eek:


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=491558

How can i quickly mark a huge range, like A1 to DV3500?
 

In the Name Box(left side of Formula Bar)

type A1:DV3500 and ENTER


Gord Dibben Excel MVP

On 7 Dec 2005 10:14:30 -0800, wrote:

Hi folks,
How can i move from A1 to DV3500 quickly without scrolling all the way
down?
What keys will achieve this?
thanks
Cricket