How to find blank cells

In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]

How to quickly select blank cells

In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]

Delete blanks and errors in a list

The formula deletes blank cells and cells with errors. It doesn't matter if the cells contain numbers or text, they […]

How to find errors in a worksheet

Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error. […]

Remove blank cells

In this blog post I will provide two solutions on how to remove blank cells and a solution on how […]