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

P

prabhu_r77

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

Phil Sharpe

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

RagDyer

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!
==============================================
 
T

tghcogo

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

Gord Dibben

In the Name Box(left side of Formula Bar)

type A1:DV3500 and ENTER


Gord Dibben Excel MVP
 
Top