How to search for terms or values in an Excel spreadsheet, and use Find and Replace

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.
Hosted on MSN

I use Excel's TAKE and DROP to make top-10 lists that update themselves

Creating top-10 lists in Excel can be tedious if you make them the way I used to. I'd sort the data manually, copy the highest values, and paste them into a separate section. It worked fine, but every ...