Forum Discussion
Excel 2016 Find Replace not working on same columns multiple sheets
I have the same issue since 2 or 3 months, Here are the steps to reproduce:
1) Open workbook with multiple sheets (mine having 13 sheet)
2) Right-click on a sheet and Select All
3) Select a bunch of cells that have values that you want to replace
4) Ctrl+h to open the replace tool
5) Type in the Find what: and the Replace with:
6) Click on Replace All
Replace will work only for the current active sheet and next one in selected only, other selected sheets will not replaced.
FYI - Although only 2 sheets will be changed when more are selected, the cells are still highlighted on all selected sheets just not changed on all sheets. Just have to select each tab not changed individually and select Replace (all) only since the cells will already be highlighted.
Still takes bit of extra work but at least you won't have to re-highlight the cells on the tabs that did not change.
