Excel TutorialLesson 9Free preview

Excel Add Cells

This lesson is part of Excel · All levels

Summary

This lesson teaches you to insert new cells, rows, and columns into existing data. You choose whether the surrounding cells are moved to the right or down, and Excel automatically adjusts the reference to the affected formula. To insert multiple lines at once, select the number of lines to be added first.

Key points

Right click on the row/column header and then insert to insert
Shift option: slide the cell to the right or down
The formula reference automatically adjusts when the cell is inserted between them
Select the number of rows you want to add to add multiple rows at once

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.