Inserting cells, columns and rows

Question 1

How to insert blank cells?

Answer 1

Select the range of cells where you want to insert the blank cells(which should be the same no. as you want to insert) and right-click on the range and select the insert option. You will get the Insert dialog box, where you click on the desired option and click OK.

Question 2

What does Shift cells right do?

Answer 2

Moves the selected cell(s) towards right.

Question 3

What does Shift cells down do?

Answer 3

Moves the selected cell(s) down by 1 row.

Question 4

What does Entire row do?

Answer 4

Moves the complete row down by 1

Question 5

What does Entire column do?

Answer 5

Moves the entire column towards right

Question 6

How to insert a new column?

Answer 6

Select the column or cell to the left of where the new column is to be inserted and click on the drop-down arrow of the Insert button in the Cells group on the Home tab and choose the Insert Sheet Columns option.

Question 7

How to Insert a new row?

Answer 7

Select the row or cell above of where the new row is to be inserted and click on the drop-down arrow of the Insert button in the Cells group on the Home tab and choose the Insert Sheet Rows option.