How to insert a cell or range

1. To insert a cell or range, select the cell or range where you want to new cell or range to appear

2. Click on the ‘Home’ tab

3. Click on the ‘Insert’ command

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

A drop down box will appear

5. When it does click on the ‘Insert cells’ command

how to insert a cell or range


A insert dialogue box will appear, see the diagram below.

6. Choose the option you want

7. Click on the ‘OK’ button at the bottom of the insert dialogue box

how to insert a cell or range1

Excel will insert a new cell or range for you.

Lesson 20: How to delete data from a range