How to insert a row

To insert a new row, left-click in a cell above the row where you want to insert a new row. See Diagram below.

Click on the ‘Home’ tab

Click on the ‘Insert’ command

Click on the down arrow next to the ‘Insert’ command

A drop down box will appear

When it does click on the ‘Insert Sheet Rows’ command

how-to-insert-a-row-or-column - 1

 

Excel will insert a new row for you.

how-to-insert-a-row-or-column - 2

 

 

Lesson 18: How to insert a column