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.
Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.
Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.
The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.
You can read his full bio here.