Forum Discussion
Excel 2016 Find Replace not working on same columns multiple sheets
For years I have been able to select multiple tabs (7+) and highlight the same columns and use the Find/Replace function (within Sheet) to update formulas. Recently this stopped functioning and only...
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.
