Forum Discussion
Change values on data sheet
Hi I need to change values from 1,2,3,4 to 0,1,2,3 on an entire data sheet. What is the best way to do this please? Thanks in advance.
If that's something like this
you may enter -1 in any empty cell, copy it, select your range and Paste->Paste special->Add->Ok
Delete -1 from the helper cell. Result is
If something like this
when one by one. Select nothing, Ctrl+H, match entire cell content, Replace All.
- Thank you.
