Insert a row, column, cell, chart, symbol quickly and efficiently just be learning these straightforward keyboard shortcut sequences. Become an Excel PowerUser!
- 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
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.
Inserts a blank row below the current cell.
ALT* + I + R
Inserts a column to the right of the current cell
ALT* + I + C
Inserts a single cell. A pop-up asks how you want it to affect the other cells.
ALT* + I + E
A pop-up asks what type of object
ALT* + I + O
ALT* + I + S
The chart will be based on the cells you select beforehand.
ALT* + I + H
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
ALT* + I + F
Other Excel Keyboard Shortcuts
- 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