Creating New Rows or Columns

Instructions for creating (inserting) new rows or columns in an Excel spreadsheet.

Issue/Question

How do I insert a new row or column in my spreadsheet?

Environment

• Microsoft Office 365
  • Excel 

Resolution

Inserting Rows

1. Highlight the row below where you want to insert the new one.
2. In the Home tab, click Insert.
3. Click Insert Sheet Rows.

Inserting Columns

1. Highlight the column after where you want the new one to be inserted.
2. In the Home tab, click Insert.
3. Click Insert Sheet Columns.