Explain the way by which you can Insert and Delete Cells in Microsoft Excel 2016.

Question

What will be an ideal response?

Answer 1

Answers will vary. If you click the Insert button in the Cells group on the Home tab while one cell is selected, a cell is inserted and the selected cell and the cells below it move down one row. If you select a range and then click the Insert button, the selected range shifts down when the selected range is wider than it is long, and shifts right when the selected range is longer than it is wide.?If you click the Insert button arrow, you can use the Insert Cells command on the menu to open the Insert dialog box. This allows you to specify whether you want to shift the existing cells right or down, or whether to insert an entire row or column. The selected option is Excel's best guess of which way you want the current cells to shift.?If you no longer need a specific cell or range in a worksheet, you can delete those cells and any content they contain. To delete a range, select the range, and then click the Delete button in the Cells group on the Home tab. As with deleting a row or column, cells adjacent to the deleted range either move up or left to fill in the vacancy left by the deleted cells. To specify how the adjacent cells shift, or if you want to delete the entire row or column, click the Delete button arrow, and then click Delete Cells to open the Delete dialog box, which is similar to the Insert dialog box. Please see the section "Working with Cells and Ranges" for more information.