How to Delete Blank Rows in Excel

Open your Excel workbook (.xlsx) in Cue Office. Right-click the row number of a completely empty row and choose Delete Selected Row. The rows below it move up. Check across the whole row first so you keep valid records with a zero fee or a blank note.

How can you tell whether a row is safe to delete?

Start with row 4 of the signup list. Its Notes cell is blank, but NW-102 still has an ID, a name, and a fee of 0. Before deleting rows 3 and 6, scan both rows from left to right, including the Control column to the right of the list. Deleting a worksheet row also removes any data in that row outside the list.

Roster showing row 3 and row 6 completely empty, while row 4 still has a signup ID and an amount of 0
Row 3 and row 6 have no data. Row 4 is a valid registration record with a fee of 0.

Which blank row should you delete first?

Right-click the row number for row 6 and choose Delete Selected Row. NW-104 moves up from row 7 to row 6. The blank row above it stays at row 3, so you can delete it by its original row number. Use the same bottom-up order when there are several blank rows.

Context menu showing Delete Selected Row after selecting row 6
Open the context menu on the empty row number, then select Delete Selected Row.

How do you check that all four signups are still there?

Save and reopen the workbook. Check that NW-101 through NW-104 appear in their original order in rows 2 through 5. Make sure NW-102 still has a fee of 0, the Notes cells for NW-102 and NW-104 are blank, and F1:F2 still show Control and Keep this.

Four signup records appearing sequentially after manual deletion, preserving zero amounts, blank notes, and control cells
The cleaned list runs continuously from row 2 to row 5.

Remove blank rows with Cue AI

To clear several blank rows at once, open Cue AI on the Home toolbar in a copy that still contains the blank rows. Select A1:F7, which covers the signup list and the check column to its right. Send the prompt from the sidebar.

Cue AI button on the Home toolbar alongside the open Cue AI sidebar
Open Cue AI from the Home toolbar and send your prompt in the sidebar.
On Sheet1, remove only the fully blank worksheet rows within rows 2 through 7. Check every column for content before deleting a row. Keep the header, all four signup records in their current order, any blank Notes cells on those records, the zero Fee, and the Control and Keep this cells in F1:F2. Apply the changes directly to this workbook.

In this example, Cue AI deleted the original rows 3 and 6. Save and reopen the workbook. Use the signup IDs to check that all four records kept their original fees, then check the blank notes and F1:F2.

NW-101 through NW-104 displayed contiguously after reopening the Cue AI modified workbook, retaining zero values and control data
When reopening the workbook processed by Cue AI, the four records appear contiguously, and F1:F2 still shows Control and Keep this.

Practice with the signup list

Create a spreadsheet in Cue Office and paste the example into A1. The pasted data includes both empty rows and the check column on the right.

Show the signup list
Signup IDParticipantFeeNotesControl
NW-101Maya25OnlineKeep this
NW-102Noah0
NW-103Iris25In person
NW-104Leo25

Check the fees and hand off the signup list

After removing the blank rows, check how much this group owes. The next time you combine signup lists, ask Cue AI to remove completely blank rows and write a SUM formula below the Fee column. This example should total 75. Before handing the list to the payments team, check that the zero-fee signup NW-102 is still there and add 25 + 0 + 25 + 25 to verify the total.

On the day of the workshop, the payments team can open PDF receipts (.pdf) in Cue Office and check them against the Excel signup list (.xlsx). The check-in team can record the zero-fee signups on a Word check-in sheet (.docx) and later update the actual headcount in the PowerPoint recap (.pptx). Cue Office includes free editing for these Office formats and free PDF reading.

Download Cue Office for free