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

Excel’s hidden REGEX and SCAN functions do way more than you expect

REGEX is a smarter version of Excel's FIND function, which works well for basic lookups. However, REGEX handles more complex ...

How to hide and unhide columns in Excel to optimize your work in a spreadsheet

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.