Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to remove blank rows in Excel and Google Sheets
Topic:Data cleaning & shapingExcel & Google Sheets
=COUNTA(A2:E2)>0✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Name | Score |
| Alice | 90 |
| Bob | 75 |
| Carol | 88 |
=COUNTA(A2:E2)>0→TRUE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Excel shortcut: Select the data range, press Ctrl+G → Special → Blanks → OK, then right-click any selected cell → Delete → Entire Row.
- 2Filter method (both apps): Add a helper column with =COUNTA(A2:E2)>0 (returns TRUE for non-blank rows). Filter for FALSE rows, select them, and delete.
- 3In Google Sheets you can also use Data → Create a Filter, filter for blanks in a key column, select visible rows, and delete them.
Tips
- Before deleting, make a backup copy of your sheet — deleting rows is irreversible unless you use Ctrl+Z immediately after.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
What if a row has a formula that returns an empty string but isn't truly blank?
COUNTA counts cells with formulas even if they return "". Use SUMPRODUCT(--(TRIM(A2:E2)<>""))>0 to check for truly non-empty content.
Is there a formula to remove blank rows automatically without deleting?
In Excel 365 or Google Sheets use FILTER to return only non-blank rows: =FILTER(A2:E6,A2:A6<>"") — this outputs a clean list without affecting the original.
More on Data cleaning & shaping
See all →How-to
How to merge two columns
Combine two columns into one with the & operator — perfect for joining first and last names into a full name.
How-toHow to create a sequential invoice number
Automatically generate sequential invoice numbers with a prefix and zero-padded counter using TEXT and ROW in Excel and Google Sheets.
How-toHow to number rows within each group
Assign sequential row numbers that restart for each group using COUNTIF with a mixed reference in Excel and Google Sheets.
How-toHow to transpose rows to columns
Flip rows and columns using the TRANSPOSE function or Paste Special to convert horizontal data to vertical and vice versa.
How-toHow to combine multiple columns into one
Merge values from several columns into one cell using the ampersand operator or CONCAT/TEXTJOIN for delimited output.
How-toHow to fill blank cells with a value
Replace empty cells with a default value using IF+ISBLANK, Go To Special fill-down, or a Power Query step for bulk data.