While working with the data, users sometimes need to insert the cell only instead of adding the new row or column and users can do the same using the insert option.
Like other Excel options and features, users can insert cells both manually using the mouse or using the keyboard shortcut.
Keyboard Shortcut to Insert Cell in the Excel
The keyboard shortcut to insert the specific cell or range of cells is as mentioned below:
Ctrl + Shift + +
Steps to Insert Cell Using Keyboard Shortcut
- First, go to the cell above of which or to the left of which you want to insert the new blank cell.
- After that, simply press the “Ctrl + Shift + + (plus) keys together and you will get the “Insert” dialog box opened.
- Now, choose the option in which direction you want to move the data to insert the new cell.
- Once selected, press enter and you will get the new cell inserted.
Note: If you have your data in the table range then the Insert cell option only will not work and it will add a row or column there.
More Shortcuts
- Absolute Reference (Excel Shortcut)
- Add Column (Excel Shortcut)
- Copy and Paste (Excel Shortcut)
- Cut and Paste (Excel Shortcut)
- Delete Cell (Excel Shortcut)
- Delete Row(s) (Excel Shortcut)
- Insert – Add Row(s) (Excel Shortcut)
- Lock Cells (Excel Shortcut)
- Merge-Unmerge Cells (Excel Shortcut)
- Paste Values (Excel Shortcut)
- Select Row (Excel Shortcut)
- Transpose (Excel Shortcut)
- Unhide Columns (Excel Shortcut)
- Open Go To Option (Excel Shortcut)
⇠ Back to Excel Shortcut Keys (Cheat Sheet PDF)