How to Remove Blank Rows in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Remove Blank Rows in Excel
Keep your spreadsheets clean and manageable
By Jerri Ledford Jerri Ledford Writer, Editor, Fact Checker Western Kentucky University Gulf Coast Community College Jerri L. Ledford has been writing, editing, and fact-checking tech stories since 1994. Her work has appeared in Computerworld, PC Magazine, Information Today, and many others. lifewire's editorial guidelines Updated on February 2, 2021 Reviewed by Michael Barton Heine Jr Reviewed by Michael Barton Heine Jr Michael Heine is a CompTIA-certified writer, editor, and Network Engineer with 25+ years' experience working in the television, defense, ISP, telecommunications, and education industries. lifewire's editorial guidelines Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook What to Know
To delete one row, right-click the row number and select Delete from the context menu that appears.Delete rows on the home tab: Find & Select > Go to Special > Blanks > OK to highlight the blank rows, then Delete > Delete Sheet Rows.To delete a single row using keyboard shortcuts, highlight the row and press Ctrl + - on your keyboard. This article explains three methods for deleting blank rows in an Excel spreadsheet in Microsoft Excel 2019, Excel 2016, and Office 365, including deleting manually, using a keyboard shortcut, and using the Find & Select option. Two Ways to Delete Individual Rows in Microsoft Excel
If you're working with a small, uncomplicated spreadsheet, there are a couple of easy ways to delete a single row or even a few rows without too much trouble. The easiest of those ways is to highlight the row by selecting the row number and then use the Ctrl + - keyboard shortcut to delete the row. This is fast and easy if you have only a small number or even the occasional wayward blank row to delete. Need to delete two or three rows in the same area on a spreadsheet? No problem. Highlight the first row, then hold down the Ctrl key on your keyboard and select the other rows. When all the rows you want to delete are highlighted, press Ctrl + - on the keyboard to delete all the selected rows. Another easy way to delete a single row in Microsoft Excel is to right-click the row number and then select Delete from the context menu that appears. This deletes only the row selected. How to Delete Empty Rows in Excel With Find & Select
If you're working with a larger worksheet in Excel, deleting rows individually, or even a few at a time, can be a pain, not to mention time-consuming. Fortunately, there's an easy way to delete all your blank rows at one time. In the worksheet where you want to delete rows, go to the Home tab and select Find & Select from the Editing group. In the menu that appears, select Go to Special. The Go to Special dialog box appears. Click the radio button next to Blanks and then click OK. This will select all the blank rows in your spreadsheet. Be careful when using this method to select blank rows. If you have rows that are only partially complete, those rows will be selected and deleted when you complete the steps in this instruction set. If you don't want to delete partially complete rows, you may need to use the Ctrl + click method of selecting rows mentioned above. With the rows selected, on the Home tab, select Delete from the Cells group. From the Delete menu, select Delete Sheet Rows. Alternatively, once the blank rows are selected, you can use the keyboard shortcut Ctrl + -. This opens a Delete dialog box, in which you should select the radio button next to Entire row and click OK. If you inadvertently delete rows that you need to bring back before you do anything else on the worksheet, press Ctrl + Z on your keyboard to undo the delete action. This will bring back all the rows you just deleted, however, so you'll need to re-delete the other rows. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Hide and Unhide Columns, Rows, and Cells in Excel How to Make a Calendar In Excel How to Limit Rows and Columns in an Excel Worksheet How to Highlight and Find Duplicates in Google Sheets How to Merge and Unmerge Cells in Excel Use Excel's EOMONTH Function to Add or Subtract Months How to Use Google Sheets How to Strikethrough In Excel How to Use the ISBLANK Function in Excel How to Move Around and Between Worksheet Tabs in Excel How to Insert a Table in Microsoft Word 2013 The Do's and Don'ts of Entering Data in Excel How to Remove Duplicates in Google Sheets How to Freeze and Unfreeze Rows or Columns in Google Sheets How to Combine Two Columns in Excel The 12 Best Tips for Using Excel for Android in 2022 Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies