how can you add cells rows or columns in excel
Answers
Answer:
To insert new cells, rows, or columns in an Excel worksheet, follow these steps:
1.Select the cells, rows, or columns where you want the new, blank cells to appear.
2.Click the drop-down arrow attached to the Insert button in the Cells group of the Home tab.
3.Click Insert Cells on the drop-down menu.
Answer:
Select the cells, rows, or columns where you want the new, blank cells to appear.
Click the drop-down arrow attached to the Insert button in the Cells group of the Home tab.
Click Insert Cells on the drop-down menu.
The Insert dialog box opens with the following options:
Shift Cells Right shifts existing cells to the right to make room for the blank cells you want to insert.
Shift Cells Down instructs Excel to shift existing cells down. This is the default option.
Entire Row inserts complete rows in the cell range. You can also select the row number on the frame before you choose the Insert command.
Entire Column inserts complete columns in the cell range. You can also select the column letter on the frame before you choose the Insert command.
I hope that you are now able to insert cell, rows and columns