Forum Discussion
Restricting Find/Replace to single column
Hi, I wish to run Find/Replace on a single column of a woeksheet. At the moment, Find/Repace replaces every occurance of the word I wish to replace on the entire workbook. I want it to only affect a ...
You should select the column first, and then in the find and replace window you have a section called within, tou should set it to Selection.
In office 365 it can only be set to "Sheet" or "Workbook" (NOT "Selection")
But the color-trick from PHB-5 works well enough.
in 365, for Excel for web you may select explicitly any of
In desktop version Selection works by default.
- Thanks,
I found that it works for search, but not for "replace all".
