Bookmark page
Printable version
Course updates
Inserting ranges
Columns and rows may need to be added to or removed from an existing spreadsheet.
In Excel, rows can only be inserted in an upward direction and columns can only be inserted to the left.
To insert rows or columns:
- Use Insert-Cells or right-click in a column or row and select Insert from the menu, then select Row or Column
- Right-click on a row or column header and select Insert from the menu
Using the Insert menu:
Click in a row or column and right-click:
Select the row or column header and right-click:
Handy hint:
Insert multiple rows or columns by selecting more than one row or column header, rightclicking and selecting Insert from the menu.
