Excel shortcuts

How to Insert in Excel: The Ultimate Shortcut Guide

If you work with Excel on a regular basis, you know that the insert function is one of the most commonly used features. Whether you're inserting a new row, column, or cell, the process is always the same: select the cell where you want the new element to be inserted, click on the insert button, and then choose the appropriate option from the drop-down menu. But what if there was a way to streamline this process and make it even faster?

With a few simple keyboard shortcuts, you can insert new rows, columns, and cells in Excel without ever having to reach for the mouse. Here's a quick guide to the most useful insert shortcuts in Excel.

Inserting a New Row

To insert a new row above the currently selected cell, use the following shortcut:

Ctrl+Shift++

If you want to insert a new row below the currently selected cell, use this shortcut instead:

Ctrl+Shift++

Inserting a New Column

To insert a new column to the left of the currently selected cell, use the following shortcut:

Ctrl+Shift+F

If you want to insert a new column to the right of the currently selected cell, use this shortcut instead:

Ctrl+Shift+P

Inserting a New Cell

To insert a new cell above the currently selected cell, use the following shortcut:

Ctrl+Shift++

If you want to insert a new cell below the currently selected cell, use this shortcut instead:

Ctrl+Shift++

You can also use the following shortcut to insert a new cell to the left of the currently selected cell:

Ctrl+Shift+F

And this shortcut to insert a new cell to the right of the currently selected cell:

Ctrl+Shift+P

Inserting a Copied Cell

If you want to insert a cell that contains a copy of the data from another cell, use the following shortcut:

Ctrl+Shift+V

This shortcut will insert a cell that contains a copy of the data from the cell that is currently selected. If you want to insert a cell that contains a copy of the data from another cell, but you don't want to overwrite the data in the cell that you're inserting into, use the following shortcut instead:

Ctrl+Shift++

This shortcut will insert a cell that contains a copy of the data from the cell that is currently selected, but it will not overwrite the data in the cell that you're inserting into. This is a great shortcut to use if you want to insert a row or column that contains data from another row or column, but you don't want to overwrite the data that is already in the cells.

Inserting a Blank Cell

If you want to insert a blank cell into your spreadsheet, use the following shortcut:

Ctrl+Shift++

This shortcut will insert a blank cell above the currently selected cell. If you want to insert a blank cell below the currently selected cell, use this shortcut instead:

Ctrl+Shift++

You can also use the following shortcut to insert a blank cell to the left of the currently selected cell:

Ctrl+Shift+F

And this shortcut to insert a blank cell to the right of the currently selected cell:

Ctrl+Shift+P

Inserting a Formula

If you want to insert a formula into a cell, use the following shortcut:

Ctrl+Shift+F

This shortcut will insert a formula into the cell that is currently selected. If you want to insert a formula into a cell that is not currently selected, use the following shortcut instead:

Ctrl+Shift+V

This shortcut will insert a formula into the cell that is to the left of the currently selected cell. If you want to insert a formula into a cell that is to the right of the currently selected cell, use this shortcut instead:

Ctrl+Shift+P

Inserting a Link

If you want to insert a link into a cell, use the following shortcut:

Ctrl+Shift+L

This shortcut will insert a link into the cell that is currently selected. If you want to insert a link into a cell that is not currently selected, use the following shortcut instead:

Ctrl+Shift+V

This shortcut will insert a link into the cell that is to the left of the currently selected cell. If you want to insert a link into a cell that is to the right of the currently selected cell, use this shortcut instead:

Ctrl+Shift+P

Inserting a Comment

If you want to insert a comment into a cell, use the following shortcut:

Ctrl+Shift+C

This shortcut will insert a comment into the cell that is currently selected. If you want to insert a comment into a cell that is not currently selected, use the following shortcut instead:

Ctrl+Shift+V

This shortcut will insert a comment into the cell that is to the left of the currently selected cell. If you want to insert a comment into a cell that is to the right of the currently selected cell, use this shortcut instead:

Ctrl+Shift+P

Inserting a Picture

If you want to insert a picture into a cell, use the following shortcut:

Ctrl+Shift+G

This shortcut will insert a picture into the cell that is currently selected. If you want to insert a picture into a cell that is not currently selected, use the following shortcut instead:

Ctrl+Shift+V

This shortcut will insert a picture into the cell that is to the left of the currently selected cell. If you want to insert a picture into a cell that is to the right of the currently selected cell, use this shortcut instead:

Ctrl</

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.