Cecilia
What you say is not enough for anyone to know how to help you. State
clearly what you have, then state clearly what you want to have. HTH Otto
"Cecilia" wrote in message
...
I have a spreadsheet that appears as follows.
How can I replace the number "1" in the cells with the values in the
topmost
cell for the reach corresponding column?? I know find and replace would
work,
but it's a large spreadsheet, so was looking for something quicker.

Thanks!!!

12 12 12 4 4 8 8
1
1
1
1
1
1
1
1
1
1

1
1

1

1