From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Select and manipulate blank cells

Select and manipulate blank cells

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Select and manipulate blank cells

“

- [Voiceover] It's not uncommon to see blank cells in Excel, sometimes in the middle of data. Sometimes it's appropriate too. Sometimes dealing with blank cells is a bit problematic. There are a number different functions related to blank cells and features too. We're looking at a worksheet called HR List and in column I, we can zoom in a little bit holding down Ctrl using the mouse wheel, there's some blank cells. And the question might come up, well, how many people do not have benefits. We could count them somehow possibly. We could also highlight them. We might wanna fill in here text that says, for example, no benefits or none. That's not necessary, but we might wanna do that. We can begin by selecting the blank cells using a feature that's not so well known. I'm first going to select column I and then on the Home tab in the ribbon, far right button, Find & Select, Go to Special, choose Blanks. Click OK. Only the blank cells are selected. And that of course does include cell I7…

Contents