Excel shortcuts

How to insert a row with a shortcut in Excel

If you're anything like me, you're always looking for ways to work faster in Excel. One way to do that is to use keyboard shortcuts instead of the mouse. Today I want to show you a keyboard shortcut that will let you insert a row in Excel.

First, let's take a look at how to insert a row using the mouse. To do that, you would click on the row header of the row where you want to insert the new row. Then you would right-click and choose Insert from the menu. That would insert a new row above the one you selected.

Now let's look at how to do the same thing with a keyboard shortcut. The shortcut is Alt + I + R. That's the letter I, then the letter R. When you hold down the Alt key and type those two letters, it will insert a new row above the one you have selected.

You can use this shortcut whether you have one row selected or multiple rows selected. If you have multiple rows selected, it will insert a new row above each of the selected rows.

That's all there is to it! I hope you found this tip helpful. If you have any questions, feel free to post a comment. I'm always happy to help.

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.