Many users need to edit their Excel worksheets quickly, but reaching for the mouse can slow you down. You can manage your spreadsheet layout entirely from the keyboard. This article explains the keyboard shortcuts and ribbon commands to insert and delete rows and columns without using a mouse.
Key Takeaways: Keyboard Navigation for Rows and Columns
- Ctrl + Shift + + (Plus): Opens the Insert dialog to add new rows, columns, or cells where your selection is active.
- Ctrl + – (Minus): Opens the Delete dialog to remove selected rows, columns, or cells.
- Alt > H > I > R or Alt > H > I > C: Uses the ribbon access keys to insert rows or columns directly above or to the left.
Excel Keyboard Shortcuts for Layout Editing
Excel provides dedicated keyboard shortcuts for common worksheet structure tasks. These shortcuts trigger the same commands you find in the right-click context menu or the Home tab. The primary requirement is that you first select one or more cells, rows, or columns using the keyboard. The action, like insert or delete, will apply based on your current selection. Knowing these shortcuts lets you restructure data tables, lists, and reports efficiently.
Selecting Rows and Columns with the Keyboard
Before you can insert or delete, you must select the target area. Use Shift + Spacebar to select the entire row of the active cell. Use Ctrl + Spacebar to select the entire column of the active cell. To select multiple adjacent rows, press Shift + Spacebar once, then hold Shift and press the Up or Down arrow keys. For multiple columns, use Ctrl + Spacebar followed by Shift + Left or Right arrow.
Steps to Insert Rows and Columns Using Shortcuts
- Select the insertion point
Use the arrow keys to move to a cell in the row below where you want the new row, or in the column to the right of where you want the new column. To insert multiple rows or columns, select an equivalent number of existing ones first using Shift + Spacebar or Ctrl + Spacebar. - Press the insert shortcut
Hold Ctrl and Shift, then press the Plus (+) key. This opens the Insert dialog box. - Choose your insert action
In the dialog, press R to insert an entire row, or press C to insert an entire column. Then press Enter. The new row(s) will appear above your selection. The new column(s) will appear to the left of your selection.
Steps to Delete Rows and Columns Using Shortcuts
- Select the rows or columns to remove
Navigate to a cell within the row or column you want to delete. Use Shift + Spacebar or Ctrl + Spacebar to select it. For multiple items, extend the selection with the arrow keys while holding Shift. - Press the delete shortcut
Hold Ctrl and press the Minus (-) key. This opens the Delete dialog box. - Choose your delete action
In the dialog, press R to delete the entire row, or press C to delete the entire column. Then press Enter. The selected rows or columns will be removed immediately.
Using Excel Ribbon Access Keys for Insert and Delete
You can also use the keyboard to navigate the Excel ribbon. This method uses Alt key sequences and is helpful if you forget the direct Ctrl shortcuts. Pressing Alt displays key tips over each ribbon tab.
- Activate the Home tab
Press the Alt key, then press H to switch to the Home tab. Key tips will now show for commands in this tab. - Open the Insert menu
Press I to open the Insert dropdown menu. From here, press R to insert sheet rows, or press C to insert sheet columns. This performs the action directly without a dialog box. - Open the Delete menu
With the Home tab active (Alt, H), press D to open the Delete dropdown menu. Press R to delete sheet rows, or press E to delete sheet columns.
Common Mistakes and Limitations to Avoid
Shortcut Opens the Dialog Instead of Immediate Action
The Ctrl + Shift + + and Ctrl + – shortcuts always open a dialog box when a single cell is selected. This is by design. For an immediate insert or delete without the dialog, you must first select entire rows or columns using Shift + Spacebar or Ctrl + Spacebar before using the shortcut. The ribbon access key method provides immediate action.
Deleting Data Instead of Entire Structures
If you press the Delete key alone, you only clear the contents of the selected cells; you do not remove the row or column from the sheet. You must use Ctrl + – to delete the entire structure. Always verify you see the Delete dialog box to confirm the correct operation.
Insert or Delete Actions Are Grayed Out
If the worksheet is protected, you cannot insert or delete rows or columns. You must first unprotect the sheet via Review > Unprotect Sheet. Also, if your workbook is in Shared Workbook mode, these editing features are restricted.
Keyboard Shortcuts vs. Ribbon Access Keys
| Item | Keyboard Shortcuts (Ctrl) | Ribbon Access Keys (Alt) |
|---|---|---|
| Primary Method | Ctrl + Shift + + or Ctrl + – | Alt > H > I / Alt > H > D |
| Speed | Faster after memorization | Slower, menu-driven |
| Dialog Box | Always appears for cell selection | No dialog, direct action |
| Best For | Users who know exact selection state | Users who prefer visual menu guidance |
| Immediate Action | Only when entire row/column is selected | Always immediate after key sequence |
You can now edit your worksheet structure quickly using only the keyboard. Practice using Shift + Spacebar and Ctrl + Spacebar to master selection before using the insert or delete shortcuts. Next, try using F4 to repeat your last insert or delete action on a new selection. For advanced editing, learn the Ctrl + Arrow key shortcuts to navigate to the edge of data regions before selecting rows or columns.