Insert Cells
- Insert › Cells and Sheets
- Shortcut menu
Makes room in the middle of a sheet by adding cells and pushing the existing ones aside. In the menu, the other things you can insert follow the Insert item.
- Select the place where the new cells should go.
- Click Insert: the cells shift down, or right if the selection is taller than it is wide.
- To choose the direction yourself, or to insert entire rows or columns, choose Insert Cells… among the items that follow Insert in the menu, or press Ctrl+Shift++ or right-click and choose Insert….
Tip Select three cells before you click and you insert three, so you rarely need to repeat the command.