Excel: insert an empty column - how it works

This practical tip explains how to insert an empty column in Excel.

How to get an empty column in your Excel spreadsheet (quick guide)

1. Select the column you want to move to the right. Use the column letter for this.
2. Right click on the selected column.
3. Select the "Insert cells" option.
4. The new column appears in your Excel document.

1. Select a column

Select the column that should be to the right of the new column.

2. Right click on the highlighted column

Right-click on the highlighted column. A menu opens.

3. Select the "Insert cells" option

Select the "Insert cells" option

4. The new column appears

You can protect individual elements in your Excel document from changes. Read how to protect formatting in Excel.