Worksheet editing cells

[lauripit]

Hello, is there a way to change a value in multiple cells at once in worksheet?

[Pat Stanford]

If you want multiple cells to have the same value, select a single cell that has the value you want and Copy. Select a range of cells you want to have that value and Paste.

 

I don't think this will work for discontinuous ranges.

 

If you select more than a single cell before you copy, those values will repeat in the paste range.

[lauripit]

On 6/27/2022 at 5:16 PM, Pat Stanford said:

If you want multiple cells to have the same value, select a single cell that has the value you want and Copy. Select a range of cells you want to have that value and Paste.

 

I don't think this will work for discontinuous ranges.

 

If you select more than a single cell before you copy, those values will repeat in the paste range.

Thanks! This is great workaround and it works fine