Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Delete Blank Rows in Excel

How to Delete Blank Rows in Excel

Asmi DhakalBy Asmi DhakalNovember 3, 2022
how to delete blank rows in excel

When you delete a data in a row, Excel replaces it with null data that appears as a blank row. In addition to this, blank rows also sometimes appear while copy-pasting data from an external row to your spreadsheet. 

In most scenarios, these blank rows serve no purpose to the spreadsheet, and you would understandably want to eliminate them. This article is for you if you wish to delete blank rows in your Excel workbook.

Table of Contents

  • How to Delete Blank Rows in Excel?
    • Remove Individual Rows
    • Use Sort & Filter Tool
    • Use Find & Select Tool
    • Use Power Query

How to Delete Blank Rows in Excel?

Here are four ways you could delete blank rows in Excel. You do not have to be experienced in Excel to attempt these methods, as they’re very beginner-friendly. Depending on the size of blank spaces you wish to remove from your spreadsheet, refer to the ways discussed below.

Remove Individual Rows

If you only have a few existing blank rows, you could individually remove these rows from your Excel grid. You can manually remove individual rows in two ways:

  • from the home tab
  • using a keyboard shortcut. 

If you prefer using shortcuts, select the row you wish to remove and hit the combination of Ctrl + (-) to remove the entire row.

Keyboard_Shortcut_Delete_Rows_Excel

Refer to the following steps if you want to remove individuals rows on Excel from the home tab:

  1. Open your Excel worksheet.
  2. Select the empty row.
  3. From the Home tab on the menu bar, select the drop-down menu for Delete.
    home-tab-excel
  4. Choose Delete Table Row.
    Delete Table Rows

Use Sort & Filter Tool

The Sort & Filter tool is a great way to categorize your data in a table. Using this tool, you can hide selected data from the table. You can also use the sort & filter tool only to show the blank rows in your table and then delete them. If you have a lot of blank rows in your table, this tool can help you get the job done quickly. 

Follow these steps to use the Sort & Filter tool to remove blank rows in your Excel spreadsheet:

  1. Launch Excel to open your file.
  2. Select your table with the empty rows.
    Select Table
  3. Head to the Home tab on the menu bar.
  4. From the Editing section, select Sort & Filter > Filter.
    Sort and Filter Excel
  5. Select the drop-down icon on the top of your table.
  6. Deselect the box next to Select All.
    Select All Sort and Filter
  7. Scroll down and select the box next to (Blanks) > OK.
    Select Blank Cell Sort and Filter
  8. Select the empty rows and use Ctrl + (-) to delete all the empty cells.
    Select Blank Cells Sort and Filter
  9. Confirm your action by choosing OK in the warning message box.
    Delete entire sheet row
  10. Click the drop-down icon next to the header and select the box next to Select All > OK.Sort and Filter Table

Use Find & Select Tool

You could also use the find & select tool to locate and select the blank rows in your Excel spreadsheet. Then, you could head to the home tab to delete the selected cells or use the keyboard shortcut to delete the empty rows. Similar to the previous method, you can use this method when you have a lot of blank rows to remove.

If you wish to use the Find & Select tool to delete blank rows from your grid, follow these steps:

  1. Open your Excel workbook. 
  2. Select your table with the empty rows, then head to the Home tab.
    home-tab-excel
  3. From the ribbon, select Find & Select > Go To Special.
    Find and Select Go To Special
  4. Select the box next to Blanks > OK.
    Go to special Excel
  5. Use the combination Ctrl + (-) on your keyboard to remove the selected blank rows.
    Find and Select Excel
  6. In the pop-up, choose where you want the corresponding rows to shift and press OK.

Use Power Query

If you’re a bit more experienced in using Excel, you can use power query to remove the blank rows from your worksheet. Compared to other methods, this method is more-straightforward as it does not require you to go through multiple ways to remove the blank sheets. If you want to use power query to delete the empty rows from your grid, follow these steps:

  1. Open your workbook, then select your table from the grid.
  2. Head to the Data tab and choose From Table from the Get & Transform section.
    Create Power Query Excel
  3. Select the drop-down menu for Remove Rows from the Home ribbon on the Power Query Editor.
  4. Choose Remove Blank Rows.
    Remove Blank Rows Excel
  5. Select Close & Load from the Home ribbon.
    Close and Load Power Query
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
how long does a cmos battery last

How Long Does a CMOS Battery Last

January 25, 2023
thunderbolt vs usb c

Thunderbolt Vs USB C: What’s the Difference

January 25, 2023
how to find hidden folder in laptop

How to Find Hidden Folder in Laptop

January 24, 2023
You may also like
how-to-connect-headphones-to-tv

5 Ways to Connect Headphones to TV

January 29, 2023
connect-airpods-to-samsung-tv

How to Connect AirPods to Samsung TV? (Step-by-Step Guide)

January 29, 2023
AIO Pump Not Working

AIO Pump Not Working? Here’s How to Fix It

January 29, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.