Select Page

Excel Video 270 Find Formats and Find All

In Excel Video 270 we’ll find cells based on the format of the cell. If you don’t care about the contents of the cell but want to find all of the cells with a red background color or a blue font, here’s how to do it. You can also find cells based on both the content...

Excel Video 269 Options in the Find and Replace Window

If you need to find comments, search throughout your Excel spreadsheet, or make your searches case sensitive, watch Excel Video 269. We’ll start on the options available in the Find and Replace window today. You’ll see how to search across an entire workbook instead...

Excel Video 268 Using Wildcards to Find

Now that we know how to find things in Excel, Excel Video 268 shows how to find parts of things. By parts of things I mean rather than looking for an entire CPT code like 99201, we can search for all of the codes that start with 992 or that end in 1. The trick is to...

Excel Video 267 Find and Replace

If you still haven’t found what you’re looking for, watch Excel Video 267 today. Excel Video 267 is the first in a series of videos about the find and replace features in Excel. As we go through the basics, watch for a potential gotcha. If you highlight an area of...

Excel Video 266 Clear

Excel Video 266 walks you through 5 different ways to clear components of your data from a spreadsheet. The Clear menu is the tool we’ll use to do the clearing. We can clear everything with Clear All, we can just remove the formats with Clear Formats, we can just...