How to Find Blank Cells in a Column in MS Excel

Save

Excel 2010 spreadsheets can contain more than a million rows of information, so with any large spreadsheet it can be almost impossible to locate blank cells by sight alone. Blank cells in a column of information can interfere with your formulas and ruin the look of the spreadsheet when a user comes across them. Excel offers two easy ways to quickly locate empty cells. The first method filters the information so that just the empty cells show up, the second sorts the entire sheet putting the empty cells at the top.

Sort Method

  • Open the Excel file that you want to work with. Select the correct spreadsheet from the list of sheets at the bottom of the window. Click on any cell in the column where you are looking for blank cells.

  • Click the "Data" tab at the top of the window. Locate the "Sort & Filter" area of the ribbon.

  • Select either the "ZA" button, to sort the information from largest to smallest, or the "AZ" button, which will do the opposite.

  • Click on any cell in the column you just sorted. Move your mouse to the very bottom of the selected cell, so that the pointer changes into a set of four arrows. Double-click the mouse button to immediately go to the last entry in that column. The blank cells are all located below this entry.

Filter Method

  • Open the Excel spreadsheet that you want to work with and choose the correct sheet from the bottom of the window. Click on any cell in the column where you are looking for blank cells.

  • Click the "Data" tab and find the "Sort & Filter" area. Click the "Filter" button. You will see drop-down arrows appear at the top of each column.

  • Select the drop-down arrow for your desired column to open up a small window. Click in the box next to "Select All" to remove all of the check marks. Scroll to the bottom of the list and place a check mark next to "Blanks."

  • Click "OK" and you will see the report get filtered to only show rows where your selected column has a blank cell.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!