Thursday, May 17, 2012

How to Find Blank Cells in a Column in MS Excel


Sort Method
1. 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.
2. Click the 'Data' tab at the top of the window. Locate the 'Sort Filter' area of the ribbon.
3. Select either the 'ZA' button, to sort the information from largest to smallest, or the 'AZ' button, which will do the opposite.
4. 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
5. 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.
6. 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.
7. 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.'
8. Click 'OK' and you will see the report get filtered to only show rows where your selected column has a blank cell.

Blogger news