Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
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 |
#15
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
How do I drag a formula from right to left columns instead of rig. | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Conditional Formatting for dates | Excel Worksheet Functions |