How to delete blank cells, rows, and columns in Excel
In Excel for Windows, select a range and use Home > Find & Select > Go To Special > Blanks to find empty cells. You can delete just those cells or delete entire rows or columns containing them. If only completely empty rows should go, check each row’s contents first.
Select blank cells in a specific range
- Select only the data you need to check. For example, choose B2:B5 to check column B below its header. Keep other tables and the rest of the sheet outside your selection.
- Choose Home > Find & Select > Go To Special. You can also press F5 to open Go To and choose Special.
- Select Blanks and choose OK.
Check that the highlighted cells are the ones you intended to select. Cells containing space characters or a formula that displays an empty string are not actually empty.
Microsoft Support guide to selecting blank cells
Delete and shift individual cells
Use the Delete dropdown on Home and choose Delete Cells. The Delete key clears cell contents without moving neighboring cells.
Shift cells up pulls up values below the gaps in the same column. Shift cells left moves values from the right into the gaps in the same row. Shifting up is useful for compacting a standalone one-column list.
In a table where names and scores belong together by row, shifting a single column can attach a score to the wrong person. Keep the blanks or review whether to remove whole rows instead.
Delete entire rows or columns that contain a blank
Delete Sheet Rows removes each selected blank’s entire row across the sheet. If B3 is blank, the same row’s A3 and C3 and cells in neighboring tables can disappear. Check row numbers in a copy before committing.
Delete Sheet Columns removes each selected blank’s entire column. If B3 is blank, other values in column B also disappear. Use this when you intend to remove the column itself.
Microsoft Support guide to deleting Excel rows and columns
Find rows that are completely empty within the table
On a blank sheet, put Alpha, a blank, and 7 in A2:C2. Leave A3:C3 empty. Enter ="" in B4 and leave A4 and C4 empty. Put Beta, 4, and 8 in A5:C5. Enter the formula below in D2.
=COUNTA(A2:C2)
Fill D2 down through D5. COUNTA returns 2, 0, 1, and 3. COUNTA includes a formula that returns an empty string and cells containing spaces, so only row 3 is a candidate for deletion.
Enter headers in A1:D1, then select all of A1:D5 and turn on Filter on the Data tab. Give the helper column a header and filter it to 0 to review the candidates. Check other cells on those worksheet rows before deleting. Avoid deleting a continuous range that includes hidden rows. You can clear the filter and select only the verified row numbers.
The same check works for columns. For example, use COUNTA on B2:B5 to check the part of column B inside the table. Review cells above and below that range before deleting the entire worksheet column.
After deleting, check row or column counts, totals, and formula errors. If anything moved or disappeared unexpectedly, undo with Ctrl+Z or refer to the saved original.




