From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Identify cells that have strikethrough

Identify cells that have strikethrough - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Identify cells that have strikethrough

“

- [Instructor] Sometimes you just need a number. You don't need a formula, you don't need something that'll automatically update. And here's the situation. Somebody is on the phone and in a rush and they just want to know how many of these meeting rooms are striked out. You got to be clever to get this one, okay? Because we can do something like this. If we just want to know how many rooms, highlight, and then in the lower right you can see that there are 71 total rooms. And if somebody said, "Hey, how many rooms?", you can do this and say 71. But now how many rooms have a strike-through? Pause the video, get that count, and I'm telling you, do not go and do this with your eyeballs. Maybe you can confirm with your eyes but make Excel do the work. Alright, pause the video, get that count, and then come on back. (relaxed jazz music) Welcome back. Here we go. I am going to highlight the rooms. I'm going to go to…

Contents