Excel shortcuts

15 Keyboard Shortcuts for Adding Rows and Columns in Excel

If you're an Excel power user, you know that adding rows and columns is a common task. And if you're a keyboard shortcut fan, you know that there are many ways to accomplish this task without using your mouse. Here are 15 keyboard shortcuts for adding rows and columns in Excel.

To insert a new row above the active cell, use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert a new row below the active cell, use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert a new column to the left of the active cell, use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert a new column to the right of the active cell, use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert multiple rows above the active cell, select the number of rows you want to insert, then use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert multiple rows below the active cell, select the number of rows you want to insert, then use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert multiple columns to the left of the active cell, select the number of columns you want to insert, then use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert multiple columns to the right of the active cell, select the number of columns you want to insert, then use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert a new row above the active cell and copy the contents and formatting of the active cell, use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert a new row below the active cell and copy the contents and formatting of the active cell, use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert a new column to the left of the active cell and copy the contents and formatting of the active cell, use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert a new column to the right of the active cell and copy the contents and formatting of the active cell, use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert multiple rows above the active cell and copy the contents and formatting of the active cell, select the number of rows you want to insert, then use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert multiple rows below the active cell and copy the contents and formatting of the active cell, select the number of rows you want to insert, then use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert multiple columns to the left of the active cell and copy the contents and formatting of the active cell, select the number of columns you want to insert, then use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert multiple columns to the right of the active cell and copy the contents and formatting of the active cell, select the number of columns you want to insert, then use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert a new row above the active cell and move the contents of the active cell up, use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert a new row below the active cell and move the contents of the active cell down, use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert a new column to the left of the active cell and move the contents of the active cell to the left, use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert a new column to the right of the active cell and move the contents of the active cell to the right, use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert multiple rows above the active cell and move the contents of the active cell up, select the number of rows you want to insert, then use Ctrl+Shift++ (press and hold the Ctrl and Shift keys, then press the + key).

To insert multiple rows below the active cell and move the contents of the active cell down, select the number of rows you want to insert, then use Ctrl++ (press and hold the Ctrl key, then press the + key).

To insert multiple columns to the left of the active cell and move the contents of the active cell to

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.