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 option | Where it applies | When to use it |
|---|---|---|
| Ribbon insertion | Windows | Add a worksheet column from a selected cell |
| Column heading menu | Windows | Add a worksheet column from its heading |
| Mac heading menu | Mac | Insert one or several adjacent columns |
| Browser heading menu | Web | Insert one or several adjacent columns |
| Insertion shortcut | Windows, Mac, and web | Insert selected whole columns with the keyboard |
| Keyboard menu access | Windows | Reach insertion through menus or Key Tips |
| Command search | Windows, depending on build | Find the insertion command by name |
| Insert copied cells | Windows and web | Insert a copy of an existing column |
| Insert cut cells | Windows and web | Relocate an existing column |
| Drag insertion | Windows and web | Move or duplicate a column by dragging |
| Table cell menu | Windows | Add a column within a table |
| Table expansion by typing | Windows with automatic expansion enabled | Extend a table with new data |
| Table expansion by pasting | Windows | Extend a table with copied data |
| Resize Table | Windows and web | Choose a larger table range |
| Automatic expansion setting | Windows | Enable table expansion when entering data |
| VoiceOver table insertion | Mac with VoiceOver | Add a table column through accessible controls |
| Browser table shortcut | Web with a Windows keyboard | Add a table column with keyboard navigation |
| TalkBack table insertion | Android with TalkBack | Choose which side receives a table column |
| Table plus button | Android phones and tablets | Add a column through table selection controls |
| Quick Access Toolbar | Windows | Keep the insertion command on the toolbar |
| Copilot editing | Eligible Microsoft 365 Windows, Mac, web, and supported iPad experiences | Request a column in natural language |
| Copilot dictation | Web with eligible Copilot access | Speak an insertion request |
| Recorded macro | Windows and Mac with macros permitted | Record and replay insertion steps |
| VBA insertion | Windows and Mac with VBA permitted | Insert a column from a macro |
| Office Scripts | Eligible Microsoft 365 Windows, Mac, and web installations | Insert a column through a script |
| Protection permission | Windows | Allow insertion while configuring protection |
| Remove sheet protection | Windows and web with authorization | Resolve a protection block |
| Insert Options | Windows | Adjust 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").InsertYou 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.