How do i "drag" a formula?

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
 
D

Dave Peterson

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

Ken Wright

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

Ragdyer

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

Ken Wright

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

RagDyeR

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

Ken Wright

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!!!!!!!!!! :)
 
R

RagDyeR

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
 
R

RagDyer

Nothing to do with (about) you Ken!

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


Regards,

RD
 
D

David McRitchie

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

RagDyeR

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Dragging countif formula with changing criteria 3
Excel Drag autofill only part of formula 3
dragging formulas acros adjacent cells 3
Excel Count If Formula Question 1
Excel Moving data to sheet2 from sheet1 0
Delete a formula but leave the data. 2
display worksheet name in a cell 0
Formula for drag and copy and paste 0

Top