by Nate Moore | Jun 27, 2012 | Basics
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...
by Nate Moore | Jun 25, 2012 | Basics
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...
by Nate Moore | Jun 20, 2012 | Basics
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...
by Nate Moore | Jun 18, 2012 | Basics
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...
by Nate Moore | Jun 13, 2012 | Basics
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...