New spreadsheets in Microsoft Excel already consist of a lot of rows and columns before you do anything.
As you add data into those rows and columns you can continue to add more and more data as needed. While there are limits to the amount of rows and columns you can have, those limits are very high and many users will never come close to reaching them.
But occasionally you will need to insert a row in Excel between existing rows that are already full of data.
This is something that you can do in Microsoft Excel, but you may not know how to accomplish it if you haven’t done it before.
Our guide below will show you how to insert a new row in Excel.
Microsoft Excel – How to Insert a Row
The steps in this article were performed in the desktop version of the Microsoft Excel for Office 365 version of the application, but will also work in most other desktop versions of Excel.
Step 1: Open your spreadsheet in Excel.
Step 2: Click on the row number below where you wish to insert the row.
Step 3: Right-click on the selected row number, then choose Insert.
Note that you can also elect to insert a row by selecting the Home tab at the top of the window, then clicking the Insert button and choosing the Insert Sheet Rows option.
You can use a similar method to insert new columns in Excel as well.
Find out how to print with gridlines in Excel if you are having difficulty reading your data when it’s printed on paper.