You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.
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.