A1x3

Whatever "x3" is supposed to represent try expressing it like this:

A1x$3

As you copy down a column the reference to A1 will increment while "x$3"
will remain constant:

A1x$3
A2x$3
A3x$3
A4x$3

--
Biff
Microsoft Excel MVP


"Sooky-la-la" wrote in message
...
I have a formula in a cell A1x3, how do i copy it to cells below, without
having to change it to A2 x3, A3 x 3 etc?