Formula

P

PL

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
 
D

David Biddulph

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.
 
G

Gary''s Student

Click on the cell containing the formula and touch CNTRL-c
Then click on the row (select the entire row) and touch CNTRL-v
 
Top