How to Delete a Row in Excel 2013

Excel spreadsheets are often the best choice available when you want to display a lot of data in an organized, sortable way.

But all of the data contained in a spreadsheet might not be important, and you may even decide that you want to delete some of it. Fortunately you can delete an entire row in Excel 2013 if it is not needed, allowing you to configure the spreadsheet to the point where it is only displaying the important information.


Deleting a Row from a Spreadsheet in Excel 2013

The steps below are specifically intended to be used in a spreadsheet that you have opened in Excel 2013. However you can follow the same process to delete rows in other versions of Excel as well.


Step 1: Open the spreadsheet that contains the row you want to delete.


Step 2: Locate the row to delete. In the example image below I am going to be deleting row 5.

locate the row to delete



Step 3: Right-click the row number at the left side of the spreadsheet, then click the Delete button.

how to delete a row in excel 2013



You can also delete a row by selecting it, clicking the Home tab at the top of the window, clicking Delete, then clicking Delete Sheet Rows.

click the delete sheet rows option



If you would like to make a row bigger, you can elect to expand the row. This is a good option if you have multiple rows of data with a cell that needs to be visible. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.