Delete rows with empty cell(s) in #Excel

Excel Tip - Delete rows with empty cells 1

Guess what?  We are going to do it with a sequence of keyboard shortcuts only.  Believe it or not, it requires only 8 key strokes:

Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r => Enter

You may download a Sample File to follow along.

Two major steps involved:

  1. Select blank cells in the range
  2. Delete “Entire row” of those selected blank cells

The keyboard shortcuts for different actions are listed below: 

Select current region

  • Ctrl+A or Ctrl+Shift+8 (note: select any cell in the range first)

Select blank cells in the selected region

  1. Ctrl+G (Go to)
  2. Alt+S (Special…)
  3. k (Blanks)
  4. Enter (OK)

Excel Tip - Delete rows with empty cells 2

Delete rows of selected (blank) cells

  1. Ctrl+- (Delete)
  2. r (Entire row)
  3. Enter (OK)

Excel Tip - Delete rows with empty cells 3

DONE DONE DONE DONE! 😁

Bare in mind that we don’t need to select an entire row to delete a row.  I found that it is a common myth.

Watch it in action on my YouTube channel:

If you like my video, please give it a thumb up, share and subscribe.  😉

 

 

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, Shortcut and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.