Feb 22 2020 06:34 PM
Hi! How can I replace values in my worksheet without including those I already replaced? I'm having trouble please I need help. Thanks in Advance.
Feb 22 2020 10:11 PM
Hi @Brickson_Dimas,
Best to my knowledge there is no tracking of the replace value, except you need to do undo
But may there are 2 ways to work around
1. You can activate the tracking changes feature to see what changes are made.
2. Replace the cell value, make sure you select them at one go and give them a different color, next time when you replace use the advance option is replace by selecting specific cell format.
Hope this might be helpful.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com
Feb 22 2020 11:06 PM