Excel shortcuts

How to Insert Rows in Excel: The Ultimate Keyboard Shortcut Guide

If you're like most people, you probably use the mouse to insert rows in Excel. But did you know that there's a faster way? With just a few keystrokes, you can insert multiple rows in Excel without even touching the mouse. Here's how:

First, select the row or rows where you want to insert the new row or rows. To do this, click on the row number at the left side of the screen. For example, if you want to insert a row between rows 3 and 4, click on row 3. To select multiple rows, hold down the Shift key and click on the row numbers of the rows you want to select. For example, to select rows 3 through 5, hold down the Shift key and click on row 3, then click on row 5. All the rows between those two will be selected.

Once you've selected the row or rows where you want to insert the new row or rows, press Alt+I, then R. That's the shortcut for inserting rows in Excel. The new row or rows will be inserted above the row or rows you selected.

If you want to insert multiple rows at once, select the number of rows you want to insert. For example, if you want to insert two rows, select two rows. To select two rows, click on the row number of the first row you want to select, then hold down the Shift key and click on the row number of the second row. All the rows between those two will be selected.

Once you've selected the number of rows you want to insert, press Alt+I, then R. That's the shortcut for inserting rows in Excel. The new rows will be inserted above the row or rows you selected.

That's all there is to it! With just a few keystrokes, you can insert multiple rows in Excel without even touching the mouse. Give it a try the next time you need to insert rows in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.