Microsoft Office

Microsoft Excel How To Add Rows

To add a row in Microsoft Excel, click the row number directly below where you want the new row, right-click, and choose Insert. Excel inserts a blank row above your selection and moves existing rows down. To add several rows at once, select the same.

Which licences fit your PC setup?

Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.

Insert a single worksheet row

Use an entire worksheet row when every column needs space for another record, such as a new customer, expense or stock item. Selecting the row number ensures that all columns move together.

  1. Open the worksheet and find the position for the new entry.
  2. Click the row number on the left, directly below that position.
  3. Right-click the selected row number and choose Insert.
  4. Enter your information in the new blank row.

For example, to place an entry between rows 6 and 7, select row 7. The inserted row becomes row 7, and the previous row 7 moves to row 8. Existing content moves down; it is not overwritten.

You can also select a cell in the target row, open Home, and choose Insert > Insert Sheet Rows in the Cells group. This is the ribbon route described in Microsoft's instructions for inserting worksheet rows.

Add multiple rows in one action

Select as many consecutive row headings as the number of blank rows you need. There is no need to insert each one separately.

  1. Click the first row number below the intended insertion point.
  2. Drag down across the row headings to select the required number of rows. Alternatively, hold Shift and click the last row heading in the block.
  3. Right-click one of the selected row numbers and choose Insert.
  4. Check the new block of blank rows before entering or pasting data.

To add three rows above row 10, select row headings 10 to 12 and insert. Excel places three blank rows before the original row 10. The selected rows can already contain data: they identify the insertion position and quantity, and their contents move down.

Use a keyboard shortcut in Excel for Windows

If you regularly insert rows while entering data, you can select and insert without reaching for the mouse.

  1. Click a cell in the row below the desired insertion point.
  2. Press Shift + Spacebar to select the entire row.
  3. Press Ctrl + Shift + Plus (+) to insert above it.

On keyboards where the plus sign shares the equals key, hold Ctrl and Shift, then press that key. With a separate numeric keypad, Ctrl + the keypad's plus key also supplies the insertion shortcut. Keyboard layouts can differ; Microsoft's Excel shortcut reference lists the Windows commands.

The selection matters. With a single cell selected in an ordinary range, Excel may display an Insert dialogue instead of immediately inserting a whole row. Choose Entire row if you want all columns to move down together.

Choose between an entire row and individual cells

Inserting a worksheet row affects the full width of the sheet. If you have separate lists side by side, check both before proceeding.

  • Entire row inserts space across every column and shifts the rows below down.
  • Shift cells down inserts space only within the selected columns. It can separate related values if the selection covers only part of a record.
  • Shift cells right moves affected cells horizontally. It does not create a worksheet row.

For a list where each row represents one complete record, inserting an entire row helps keep names, dates and amounts aligned.

Insert rows within an Excel table

An Excel table is a structured range created with Excel's table feature. Use its table insertion command when you need another record within that table.

  1. Right-click a cell in the table's data row below the required position.
  2. Open Insert in the context menu.
  3. Choose Table Rows Above.
  4. Enter the new record and check its formatting and any calculated values.

When you select a cell in the last table row, Table Rows Below is also available. You can also extend a table by typing directly beneath its last row. These options are covered in Microsoft's guide to adding table rows.

Check formatting and formulas after inserting

A new row may inherit formatting from nearby cells. Check that dates, currency values and text use the intended number formats. If the Insert Options button appears, use it to adjust the inherited formatting.

Check formulas separately from appearance. A blank row in an ordinary range may need formulas copied into it, and totals should include the intended records. Review the formula range after adding entries at the edge of a list.

If the row lands in the wrong position, use Undo immediately, then select the correct row heading and try again.

For other worksheet and application tasks, browse the Microsoft Office guides. If you are also handling Office setup, related articles cover activating Microsoft Office using Command Prompt and finding a Microsoft Office product key using Command Prompt.

Now insert the rows you need, enter one new record, and check its formatting and the affected totals before filling the remaining rows.

Other editions for separate workloads

Other editions for separate workloads; prices in AUD, confirm the total on the listing.

How to check this worked

  1. Open Settings, System, Activation and confirm the edition shown.
  2. Enter the key and run activation; expect a green tick within a minute.
  3. Reboot and re-check activation survives the restart.

FAQ

What else should you know before buying?

What do I need before starting?
Read the requirements and confirm the edition first; the steps assume the machine is compatible.
How do I know the licence is genuine?
Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
Is this a subscription?
Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
What if the key fails?
Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.

Check who prepared and reviewed this guide

Written by
MS.Codes editorial
Reviewed by
Support team

Last verified: (source review; see test status above).

Recent Post