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