Insert a row, column, cell, chart, symbol quickly and efficiently just be learning these straightforward keyboard shortcut sequences. Become an Excel PowerUser!
Keyboard Shortcuts
- Insert a Row
- Insert a Column
- Insert a Cell
- Insert an Object
- Insert a Symbol
- Insert a Chart
- Define a Range Name
- Insert Page Breaks for printing
- Insert a New Worksheet
- Insert a Function
Key
or * = Hold this key down while tapping the white keys in sequence indicated.
= Tap this key(s) in sequence indicated (if there is more than one) whilst holding down the grey key.
Keyboard Shortcuts
Insert Row
Inserts a blank row below the current cell.
ALT* + I + R
Insert Column
Inserts a column to the right of the current cell
ALT* + I + C
Insert Cell
Inserts a single cell. A pop-up asks how you want it to affect the other cells.
ALT* + I + E
Insert Object
A pop-up asks what type of object
ALT* + I + O
Insert Symbol,
e.g. €
ALT* + I + S
Insert Chart
The chart will be based on the cells you select beforehand.
ALT* + I + H
Define Name
You can define a range of cells by giving them a name.
ALT* + I + N + D
Insert Page Break
Sets the page breaks for printing the spreadsheet.
ALT* + I + B
Insert New Worksheet
ALT* + I + W
Insert Function
ALT* + I + F
Other Excel Keyboard Shortcuts
- Navigation
- Selection
- Deleting
- Values
- Standard Office Commands (these work on other Office applications too)
Other excel help
Follow our Blog to get free, useful Excel advice.
Our Business Spreadsheets page offers complementary downloads that demonstrate daily office tasks using Excel Spreadsheets
