How do i "drag" a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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 said:
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 said:
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
Click to expand...
and
Click to expand...
 
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 said:
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 !
-------------------------------------------------------------------------- -
Click to expand...
 
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 !
--------------------------------------------------------------------

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 said:
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 !
-------------------------------------------------------------------------- -
Click to expand...
 
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!!!!!!!!!! :-)
 
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 !
--------------------------------------------------------------------

Hi Ken

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

Cheers
JulieD
 
Nothing to do with (about) you Ken!

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


Regards,

RD
 
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.
 
Yes to the first question David.
--

Regards,

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

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