• Skip to main content

Master Your Tech

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Excel / How to Insert a Row in Microsoft Excel for Office 365

How to Insert a Row in Microsoft Excel for Office 365

posted on August 15, 2020

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.

select the row number below

Step 3: Right-click on the selected row number, then choose Insert.

Microsoft Excel how to insert a row

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.

click Home, then Insert, then Insert Sheet Rows

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
Matthew Burleigh

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.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2023 MasterYourTech.com