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