How To Add Columns In Microsoft Excel

To add a column in Microsoft Excel, click the letter of the column immediately to the right of where you want the new one, then right-click and choose Insert. Excel inserts a blank column to the left and shifts existing columns right. To add several.

Insert a single worksheet column

Use this method when you need space for a new field, such as a delivery date or a calculated total. Selecting the column letter ensures the insertion affects the full height of the worksheet.

1. Open your workbook and select the worksheet you want to edit.
2. Click the column letter to the right of the insertion point. To add a column between B and C, select C.
3. Right-click the selected column letter and choose Insert.
4. Check the result: the new blank column is C, and the previous contents of C move to D.

You can also use Home > Insert > Insert Sheet Columns on the ribbon. Open the Insert menu on the Home tab, rather than the separate Insert tab. Microsoft documents both methods in its guide to inserting and deleting worksheet columns.

Inserting a whole column shifts cells throughout the sheet, including data above or below your main list. Check for other lists or calculations in the same columns before making the change.

Add multiple columns at once

You do not need to repeat the insertion for each new column. Select adjacent column letters to reserve the amount of space you need.

1. Click the first column letter to the right of the insertion point.
2. Drag across the column letters until you have selected as many columns as you want to add.
3. Right-click the selection and choose Insert.

For example, selecting C, D and E inserts three blank columns before the original C. The original data moves right together. In Excel for the web, the command may explicitly state how many columns will be inserted to the left.

Use the keyboard in Excel for Windows

1. Select a cell in the column immediately to the right of the intended position.
2. Press Ctrl+Space to select the entire column.
3. Hold Ctrl and Shift, then press the plus/equal key to insert a column.

On a keyboard with a numeric keypad, Ctrl and the keypad plus key also work. Selecting the entire column first avoids a prompt asking whether you want to shift individual cells. These commands appear in Microsoft's Excel keyboard shortcut reference; key combinations can differ with keyboard layout and platform.

Choose between a sheet column and a table column

An Excel table is a defined data range with its own headers and table controls. Adding a column within that table is different from inserting a full worksheet column.

To insert a table column, right-click a cell in the table column immediately to the right of the desired position, choose Insert, then Table Columns to the Left. Enter a descriptive heading in the new table header. Microsoft's table resizing guidance also explains how to extend an existing table.

If you meant to total a column rather than insert one, select an empty cell below the numbers and enter a formula such as =SUM(B2:B10). Replace B2:B10 with your actual data range, keeping the total cell outside that range.

Label and fill the new column

Add a heading in a cell

Type a label such as Quantity or Total in your data's header row. For a list whose headings occupy row 1, the heading for a new column C belongs in C1.

The worksheet letters A, B and C remain column references. Typing into the Name Box defines a name for a cell or range; it does not replace those letters with a heading.

Copy a calculation down the column

Suppose columns A and B contain numbers and your new column C will hold their combined value.

1. Select C2 and type =A2+B2.
2. Press Enter, then select C2 again.
3. Drag the fill handle at the bottom-right corner of C2 down to the last required row.
4. Check a copied formula: C3 should contain =A3+B3.

In an ordinary worksheet range, entering a formula fills only the selected cell. You must copy it to the remaining rows. Relative references adjust as you fill down, as explained in Microsoft's formula filling instructions.

Format and check the result

Drag the right boundary of the column letter to adjust its width, or double-click that boundary to fit the contents automatically. Select the data cells and use the Home tab's number formats for dates, currency or percentages. Check the formatting even if Excel copied it from an adjacent column.

If you inserted the column in the wrong place, use Undo immediately. To remove an unwanted whole column, select its letter and choose Delete from the right-click menu. Pressing the Delete key clears cell contents without removing the column.

For other workbook tasks, browse the Microsoft Office guides. If Office setup is also part of your work, separate articles cover activating Microsoft Office using CMD and finding a Microsoft Office product key using Command Prompt.

Now insert the column you need, give it a heading, and check the first few entries or formula results before saving the workbook.