How do I...
Add or delete rows and columns
What to do
- Right-click the row number or column letter.
- Choose Insert, or Delete.
Good to know
- New rows go above the one you clicked, and new columns go to the left.
- Select several rows first to add that many at once.
- Deleting cells that a formula uses can cause #REF!.
The idea in general
Formulas that refer to moved cells adjust by themselves.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.