From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Using three functions to track worksheet cells that are text, numbers, or formulas

Using three functions to track worksheet cells that are text, numbers, or formulas - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using three functions to track worksheet cells that are text, numbers, or formulas

“

- [Instructor] It's important 2 when working with some worksheets 3 to identify which cells have formulas in them, 4 which have text, which have numbers. 5 We can do this by way of Excel functions, 6 by way of certain Excel commands 7 and also by using conditional formatting. 8 Let's first approach this as if we're kind of in a hurry 9 and we simply want to know, 10 we're not concerned 11 about what's going to happen in the future. 12 Let's take a look at this same data 13 that's on a separate worksheet down here called Snapshot. 14 And off to the right in this pink panel, 15 you'll see what we're about to do. 16 There are commands that allow us 17 to quickly highlight cells that have formulas. 18 We begin the process 19 by either selecting the entire worksheet 20 or simply clicking on a single cell. 21 And it makes no difference what that cell contains. 22 Or if it's empty. 23 Home Tab, off to the right in the…

Contents