How to Add Rows in Excel

Microsoft Excel is the most commonly used program to do spreadsheets. It has many functions and tools to make doing spreadsheets simple. One function it has is to add additional rows to a spreadsheet. You can also delete and hide rows. In a few simple steps, you will be able to add single rows and multiple rows, delete rows and hide rows to an Excel Spreadsheet.

Single row:

1. Right click on the row header below where you want the new row added.


2. Choose “Insert” from the menu.


3. Inserted above the row you selected, will be the new row.

Multiple Rows:

1. Select the number of rows you want added to the worksheet in the row reader.


2. Right click on the selected rows.


3. Choose “Insert” from the menu.


4. Inserted above the rows you first selected, will be the new rows.

Delete Rows:

1. Select the number of rows you want to delete from the worksheet in the row header


2. Right click on the selected rows.


3. Choose “Delete” from the menu, and the rows will be deleted.

Hide Rows:

1. Drag and select the rows in the row header to highlight all of the rows you want to hide.


2. Right click on the selected rows.


3. Choose “Hide”  from the menu, and the selected rows will be hidden from view.