How to Insert an Empty Column

– How to Insert a Column with Copied Contents

When working with an Excel spreadsheet, you often need to insert an empty column for new data entry. You can add as many as columns you need. Please follow the steps below to insert an empty column:

Step 1: Click the column header to highlight the column to the right of the column you want to insert;

Step 2: Right-click and select "Insert"in the list;

Step 3: A new empty column will appear.

– Alternatively, you can use the commands in the ribbon.

Step 1: Highlight the column to the right of the column you want to insert;

Step 2: Click the Home Tab from the ribbon;

Step 3: Click "Insert" command in the Cells area;

Step 4: A new column will be inserted.

Leave a Reply

72 Excel Shortcuts 
Print Version 
FOR FREE!!

Download this free Excel Shortcuts Cheat Sheet print version to save your time in your daily work!
Yes, I want it!
Subscribe to receive more excellent notes for free!
close-link