You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.
MUO on MSN
I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me
With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...
You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback