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.
Step 3: Right-click the row number at the left side of the spreadsheet, then click the Delete button.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.