How do i "drag" a formula?
 

i have an excel worksheet to do and i have been instructed to drad a formula
and i have no idea what that means.

thanks
spencer

In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where you see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a bunch of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag and drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad a formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

You can also try double-clicking the little square thingy, and the formula
will autofill down as far as there is contiguous data in the column to the
left of the formula.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where you
see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a bunch of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag and
drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad a
formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

OR, to the Right, *also*.

If both are populated, the length of the left Column takes precedence.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ken Wright" wrote in message
...
You can also try double-clicking the little square thingy, and the formula
will autofill down as far as there is contiguous data in the column to the
left of the formula.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"Dave Peterson" wrote in message
...
In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where you
see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a bunch
of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag
and
drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad a
formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

Hmmm - Tried it on my machine before posting, on Excel XP and no joy at all
with data to the right. Will have another play though.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
OR, to the Right, *also*.

If both are populated, the length of the left Column takes precedence.
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Ken Wright" wrote in message
...
You can also try double-clicking the little square thingy, and the
formula
will autofill down as far as there is contiguous data in the column to
the
left of the formula.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"Dave Peterson" wrote in message
...
In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where
you
see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a bunch
of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag
and
drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is
checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad a
formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

Your uncertainty made me doubt myself.

It does work on my XL02.
--

Regards,

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

"Ken Wright" wrote in message
...
Hmmm - Tried it on my machine before posting, on Excel XP and no joy at all
with data to the right. Will have another play though.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
OR, to the Right, *also*.

If both are populated, the length of the left Column takes precedence.
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Ken Wright" wrote in message
...
You can also try double-clicking the little square thingy, and the
formula
will autofill down as far as there is contiguous data in the column to
the
left of the formula.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"Dave Peterson" wrote in message
...
In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where
you
see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a bunch
of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag
and
drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is
checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad a
formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

and on my XL 2003 - which totally surprised me!

JulieD

"RagDyeR" wrote in message
...
Your uncertainty made me doubt myself.

It does work on my XL02.
--

Regards,

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

"Ken Wright" wrote in message
...
Hmmm - Tried it on my machine before posting, on Excel XP and no joy at
all
with data to the right. Will have another play though.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
OR, to the Right, *also*.

If both are populated, the length of the left Column takes precedence.
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Ken Wright" wrote in message
...
You can also try double-clicking the little square thingy, and the
formula
will autofill down as far as there is contiguous data in the column to
the
left of the formula.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission
:-)

--------------------------------------------------------------------------
--

"Dave Peterson" wrote in message
...
In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where
you
see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a
bunch
of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag
and
drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is
checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad
a
formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

Also works on XL 97

Gord

On Mon, 31 Jan 2005 23:06:36 +0800, "JulieD"
wrote:

and on my XL 2003 - which totally surprised me!

JulieD

"RagDyeR" wrote in message
...
Your uncertainty made me doubt myself.

It does work on my XL02.
--

Regards,

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

"Ken Wright" wrote in message
...
Hmmm - Tried it on my machine before posting, on Excel XP and no joy at
all
with data to the right. Will have another play though.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
OR, to the Right, *also*.

If both are populated, the length of the left Column takes precedence.
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Ken Wright" wrote in message
...
You can also try double-clicking the little square thingy, and the
formula
will autofill down as far as there is contiguous data in the column to
the
left of the formula.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission
:-)

--------------------------------------------------------------------------
--

"Dave Peterson" wrote in message
...
In most cases, it means to type your formula in a cell (say A1).

Then move your cursor to the bottom right corner of that cell--where
you
see a
little square like thingy. (Sometimes called the AutoFill button).

Click on that and drag down.

If you rightclick on that autofill button and drag, you'll see a
bunch
of
options when you release the button.

===
If you don't see that little autofill button, make sure you have drag
and
drop
enabled.

Tools|options|edit tab|Make sure "allow cell drag and drop" is
checked.



Spencer wrote:

i have an excel worksheet to do and i have been instructed to drad
a
formula
and i have no idea what that means.

thanks
spencer

--

Dave Peterson

Something was going nuts somewhere because it works fine on mine now, but I
really really really did try it before posting. I'd screwed up an answer to
another post earlier and was getting paranoid so trying to check everything
before posting. Now I'm even more paranoid!!!!!!!!!! :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

<snip

Hi Ken

i'm glad i'm not the only one that that happens too :)

Cheers
JulieD

"Ken Wright" wrote in message
...
Something was going nuts somewhere because it works fine on mine now, but
I
really really really did try it before posting. I'd screwed up an answer
to
another post earlier and was getting paranoid so trying to check
everything
before posting. Now I'm even more paranoid!!!!!!!!!! :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

<snip

FWIW,

I believe that this might have *always* been around.

Just tried it on an old XL5.0 WB I dragged out of the archives, and it
worked there.
--

Regards,

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

"JulieD" wrote in message
...
Hi Ken

i'm glad i'm not the only one that that happens too :)

Cheers
JulieD

"Ken Wright" wrote in message
...
Something was going nuts somewhere because it works fine on mine now, but
I
really really really did try it before posting. I'd screwed up an answer
to
another post earlier and was getting paranoid so trying to check
everything
before posting. Now I'm even more paranoid!!!!!!!!!! :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

<snip

LOL - Go on RD, twist the knife in whilst I'm squirming here :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip

Nothing to do with (about) you Ken!

I used 5.0 for 5 years and never realized that it even existed.<g
--


Regards,

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

"Ken Wright" wrote in message
...
LOL - Go on RD, twist the knife in whilst I'm squirming here :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip

Would that five years coincide with either not knowing about
newsgroups or not having access to newsgroups.

Anyway that mouse shortcut is in HELP, but Microsoft products
poorly document mouse shortcuts in general.
For additional mouse shortcuts see
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
Warning: for those who suffer from Musophobia there is an
illustration of a mouse. You can close your eyes while looking
at the page or turn off images.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RagDyer" wrote in message
I used 5.0 for 5 years and never realized that it even existed.<g

Yes to the first question David.
--

Regards,

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

"David McRitchie" wrote in message
...
Would that five years coincide with either not knowing about
newsgroups or not having access to newsgroups.

Anyway that mouse shortcut is in HELP, but Microsoft products
poorly document mouse shortcuts in general.
For additional mouse shortcuts see
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
Warning: for those who suffer from Musophobia there is an
illustration of a mouse. You can close your eyes while looking
at the page or turn off images.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RagDyer" wrote in message
I used 5.0 for 5 years and never realized that it even existed.<g