Filling values in a grid
Choose Edit Replace Find: '1' Replace with '=1:1' then copy and paste
values.
Cecilia wrote:
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
|