When it comes time to print out that perfection, you get blank pages, missing sections, and weird formatting. You can blame your printer, but the problem is almost always in Excel.

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells.

To count blank or empty cells in Excel or Google Sheets, follow these steps: Open the spreadsheet in Google Sheets or Excel. Choose the column. Click on a cell where you want to show the number.