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
|