# How to insert multiple rows in microsoft excel

> To insert multiple rows in Excel, open your file and highlight the intended cells. Click the bottom corner of the cell, hold the Shift key, highlight the desired number of rows to insert, release the key, and edit the cells accordingly.

Canonical: https://livedemo.ai/tutorials/how-to-insert-multiple-rows-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3ffeab56e05a00fe80ea/preview?step=1

## Steps

1. Open the file you wish to edit and add a row or series of rows.
2. Highlight the cells where you intend to insert the row.
3. Click the bottom corner of the cell, then hold down the "Shift" key on your keyboard.
4. While holding down the 'Shift' key, highlight the number of rows you want to insert, then release the key.
5. Edit the cells accordingly.