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

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

<prabhu_r77@hotmail.com> wrote in message
news:1133979270.719160.11700@g49g2000cwa.googlegroups.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
>

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........................

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


<prabhu_r77@hotmail.com> wrote in message
news:1133979270.719160.11700@g49g2000cwa.googlegroups.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
>

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, prabhu_r77@hotmail.com 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