Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
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 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.