Hi

If I want all the cells in Row X to follow the same formula, how do I so
without dragging and pulling to infinity?

Using Excel 2003.


Thank you

X isn't a row, it's a column.

Type X1:X65536 into the name box (top left, to the left of the formula bar),
then type or copy your formula into the formula bar.
--
David Biddulph


PL wrote:
Hi

If I want all the cells in Row X to follow the same formula, how do I
so without dragging and pulling to infinity?

Using Excel 2003.


Thank you

Click on the cell containing the formula and touch CNTRL-c
Then click on the row (select the entire row) and touch CNTRL-v
--
Gary''s Student - gsnu200907


"PL" wrote:

Hi

If I want all the cells in Row X to follow the same formula, how do I so
without dragging and pulling to infinity?

Using Excel 2003.


Thank you