Fix Ctrl+Plus Not Inserting a Column in Microsoft Excel
Question details
The user wants to insert a new column in Microsoft Excel using Ctrl+Plus, but the shortcut does not work even though Ctrl+Minus deletes a column.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Inserting a worksheet column with a keyboard shortcut.
- Observed behavior
- Ctrl+Minus successfully deletes a column, but Ctrl+Plus does not insert a new column.
Click the column letter to select the entire column before inserting; the new column will appear to its left. Check whether your keyboard has a numeric keypad, since using the main keyboard's plus sign may require Shift.
Use the correct plus-key shortcut to insert a column
Use this method in Excel for Windows when Ctrl+Plus does not respond or your keyboard has no numeric keypad.
Click the column letter immediately to the right of where you want the new column. For example, select column B to insert a new column between A and B.
If your keyboard has a numeric keypad, hold Ctrl and press the keypad's + key. On a standard US keyboard without a numeric keypad, press Ctrl+Shift+= to enter Ctrl+Plus.
Look for a new blank column to the left of the selected column. If an Insert dialog appears because you selected only a cell, choose Entire column and click OK.
Insert a column from the Home tab or right-click menu
Use Excel's insertion commands if the shortcut is unavailable or still does not work.
Insert and edit spreadsheet columns with WPS Office
WPS Office is a free, lightweight alternative for everyday spreadsheet editing. Its familiar interface and support for Excel files make it easy to move your work to WPS Spreadsheets and insert columns through the right-click menu without relying on a keyboard shortcut.
Frequently Asked Questions
Why does Ctrl+Minus work but Ctrl+Plus does not?
On a standard US keyboard, the main keyboard's plus sign shares a key with = and requires Shift. In Excel for Windows, use Ctrl+Shift+= or Ctrl with the numeric keypad's + key rather than Ctrl+=.
How do I insert a column without a numeric keypad?
Select the entire column by clicking its letter, then press Ctrl+Shift+= on a standard US keyboard in Excel for Windows. You can also use Home > Cells > Insert > Insert Sheet Columns.
Why does Excel show an Insert dialog instead of adding a column immediately?
If only a cell or partial range is selected, Excel may ask what to insert. Choose Entire column and click OK, or cancel and select the column letter before using the insertion command.
Where does Excel place the new column?
Excel inserts the new column to the left of the selected column. To add a column between A and B, click the B column header and then use Home > Cells > Insert > Insert Sheet Columns.
What should I check if the Insert command is disabled?
Go to Review and check whether Unprotect Sheet is available. A protected worksheet may block column insertion. Ask the sheet owner to unprotect it or allow column insertion if you do not have the required permission or password.
