How to Insert a Column in Excel

Learn how to add a column in Excel by right-clicking a column heading and choosing Insert, plus shortcuts and steps for Mac and the web.

Contents

Don't Miss the Good Stuff

Get tech news that matters delivered to your inbox.

To add a column in Excel for Windows, right-click the column letter immediately to the right of where you want the new column, then select Insert. You can also select a cell in that column and choose Home > Insert > Insert Sheet Columns. The desktop steps below apply to Excel for Microsoft 365 and Excel 2024, with separate instructions for Mac and Excel for the web.

The short version

  • Placement: On Windows and the web, select the column immediately to the right of your intended insertion point.
  • Windows: Right-click the column heading and select Insert.
  • Mac: Hold Control, click the column heading, and select Insert.
  • Browser: Right-click the column heading and select Insert Columns.
  • Multiple columns: Select multiple whole columns before using your platform’s insertion shortcut to add the corresponding number.

Method or optionWhere it appliesWhen to use it
Ribbon insertionWindowsAdd a worksheet column from a selected cell
Column heading menuWindowsAdd a worksheet column from its heading
Mac heading menuMacInsert one or several adjacent columns
Browser heading menuWebInsert one or several adjacent columns
Insertion shortcutWindows, Mac, and webInsert selected whole columns with the keyboard
Keyboard menu accessWindowsReach insertion through menus or Key Tips
Command searchWindows, depending on buildFind the insertion command by name
Insert copied cellsWindows and webInsert a copy of an existing column
Insert cut cellsWindows and webRelocate an existing column
Drag insertionWindows and webMove or duplicate a column by dragging
Table cell menuWindowsAdd a column within a table
Table expansion by typingWindows with automatic expansion enabledExtend a table with new data
Table expansion by pastingWindowsExtend a table with copied data
Resize TableWindows and webChoose a larger table range
Automatic expansion settingWindowsEnable table expansion when entering data
VoiceOver table insertionMac with VoiceOverAdd a table column through accessible controls
Browser table shortcutWeb with a Windows keyboardAdd a table column with keyboard navigation
TalkBack table insertionAndroid with TalkBackChoose which side receives a table column
Table plus buttonAndroid phones and tabletsAdd a column through table selection controls
Quick Access ToolbarWindowsKeep the insertion command on the toolbar
Copilot editingEligible Microsoft 365 Windows, Mac, web, and supported iPad experiencesRequest a column in natural language
Copilot dictationWeb with eligible Copilot accessSpeak an insertion request
Recorded macroWindows and Mac with macros permittedRecord and replay insertion steps
VBA insertionWindows and Mac with VBA permittedInsert a column from a macro
Office ScriptsEligible Microsoft 365 Windows, Mac, and web installationsInsert a column through a script
Protection permissionWindowsAllow insertion while configuring protection
Remove sheet protectionWindows and web with authorizationResolve a protection block
Insert OptionsWindowsAdjust inherited column formatting

Choose the insertion point on Windows

Select the column immediately to the right of where the new column belongs. For example, to insert before column C, right-click the C heading and select Insert. Selecting the heading gives you the worksheet column insertion command.

If you already have a cell selected, you can use the ribbon instead. Select a cell in the column immediately to the right of the insertion point, open Home > Insert, then select Insert Sheet Columns.

Add columns on Mac or in your browser

On Mac, select a column heading. Hold Control while clicking the selection, then select Insert. To insert several columns together, select the same number of column headings as you want new columns before opening the menu.

In Excel for the web, select the heading to the right of the insertion point, right-click it, and select Insert Columns. For multiple columns, select as many adjacent headings as you need new columns, then right-click the selection and choose Insert Columns.

Insert columns with the keyboard

Select the destination column heading before pressing your insertion shortcut. On Windows, press Ctrl + Shift + +; on Mac, press Control + Shift + =. In Excel for the web, press Ctrl + +.

For several new columns, select multiple whole columns before using the shortcut. Excel inserts the corresponding number of columns. Microsoft lists these shortcuts for US keyboard layouts.

On Windows, you can also select a whole column, press Shift + F10 or the Windows Menu key, then choose Insert. Alternatively, press Alt and follow the displayed Key Tips to Home > Insert > Insert Sheet Columns.

Add a column to an Excel table

For an Excel table on Windows, right-click a table cell and select Insert > Table Columns to the Left. When you select a cell in the table’s rightmost column, Table Columns to the Right is also available. These commands insert a table column rather than an entire worksheet column.

To extend a table on Windows, enter data in a cell immediately to the right of its last column. Excel includes the new column when automatic table expansion is enabled. You can also copy the new column’s data and paste it immediately to the right of the table’s rightmost column.

If typing beside the table does not expand it on Windows, open File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type. Check Include new rows and columns in table. Subsequent entries beside the table can then expand it.

To choose the table range on Windows or the web, select a table cell and open Table Design > Resize Table. Select a range that includes the existing table and the additional columns, then select OK. Excel for the web does not have the automatic expansion settings described above, so use Resize Table there to extend the range.

With VoiceOver on Mac, select the destination table cell and navigate to Home > Insert. Activate Insert table columns to the left with Control + Option + Spacebar. In the final table column, Insert table columns to the right is also available.

In Excel for the web with a Windows keyboard, select a cell in the table column immediately to the right of the insertion point. Press Alt + Windows logo key, followed by H, I, and L.

Insert a copy or move an existing column

To insert a copy on Windows or the web, select the source column heading and choose Home > Copy. Right-click the destination column heading immediately to the right of the insertion point, then select Insert Copied Cells.

Moving a column relocates it from its original position. On Windows or the web, select the source column heading and choose Home > Cut. Right-click the destination column heading and select Insert Cut Cells.

Automate repeated column insertion

On Windows or Mac, you can record an insertion when the Developer tab is visible and macros are permitted. Select Developer > Record Macro, enter a Macro name, and choose a location under Store macro in. Optionally assign a Shortcut key, then select OK.

Perform the column insertion, then select Developer > Stop Recording. To replay it, open Developer > Macros, select the recording, and select Run. Recorded selections can target fixed locations, so check the destination before replaying the macro.

If you already use VBA on Windows or Mac and VBA is permitted, execute the following statement in a macro to insert before column C. Change the column reference to match your intended position; VBA insertion does not apply to Excel for the web.

ActiveSheet.Columns("C:C").Insert

You can also use Office Scripts in eligible Microsoft 365 installations on Windows, Mac, and the web. Personal and Family availability is in preview and requires Microsoft 365 Insider participation, and organizational policy can disable scripts. Select Automate > New Script > Create in Code Editor, then enter this script:

function main(workbook: ExcelScript.Workbook) { workbook.getActiveWorksheet().getRange("C:C").insert(ExcelScript.InsertShiftDirection.right); }

The script inserts a worksheet column before column C on the active worksheet. Select Run to execute it.

Fix the inserted column’s formatting

After inserting a column on Windows, select Insert Options to adjust the formatting it inherits. This changes the inserted column’s appearance; it does not enable insertion.

If the button is missing, open File > Options > Advanced. Find Cut, copy and paste, then check Show Insert Options buttons.

Fix worksheet protection that blocks insertion

If you are authorized to remove worksheet protection on Windows, select Review > Unprotect Sheet. Enter the protection password when required, then insert the column normally.

In Excel for the web, open Review > Manage Protection and turn off Protect sheet. Authenticate when requested, then insert the column normally. This route also requires authorization and any protection password.

When configuring protection for your own worksheet on Windows, you can allow column insertion within the protection settings. Select Review > Protect Sheet and, under Allow all users of this worksheet to, check Insert columns. Complete the protection settings so users can use an ordinary insertion command.

Frequently Asked Questions

How do I find the insertion command through Excel Search?

In Excel for Microsoft 365 or Excel 2024 for Windows, select the destination column and press Alt + Q. Type Insert Sheet Columns and select the matching command. Search may be labeled Tell Me, and command availability and results vary by build.

How do I add an insertion button to the Quick Access Toolbar?

In Excel for Microsoft 365 or Excel 2024 for Windows, open Home > Insert, right-click Insert Sheet Columns, and select Add to Quick Access Toolbar. Afterward, select the destination column and activate that toolbar command.

How do I add a table column on Android?

On an Android phone or tablet, tap the selection block at the top of a table column, then tap the + button. With TalkBack, select the destination table cell, open More options, open the tab menu, and select Table. Navigate to Insert left or Insert right and double-tap.

Which keys do I hold when dragging a column?

Moving a column relocates it from its original position. In Excel for Microsoft 365 or Excel 2024 for Windows, select the source column and drag its selection border to the destination while holding Shift to move and insert, or Ctrl + Shift to copy and insert. In Excel for the web, drag without modifier keys to move and insert, or hold Ctrl to copy and insert. Keep any modifier keys held until you release the mouse.

How do I ask Copilot to insert a column?

In Copilot-enabled Excel for Microsoft 365 on Windows or Mac, Excel for the web, or a supported iPad experience, select the Copilot icon in the lower-right corner and choose Allow editing. Identify the worksheet, destination, and desired column, for example: Insert a blank worksheet column immediately before column C on Sheet1. Review the resulting workbook to confirm the requested change. Access depends on your entitlement, organizational settings, and rollout.

How do I dictate a column request to Copilot?

In Excel for the web with eligible Copilot access, open Copilot in editing mode. Start dictation with Alt + Shift + H on Windows or Option + Shift + H on Mac. You could say Insert a blank worksheet column immediately before column C on Sheet1. Review the transcription and submit it.

Share