Page 72 - 2422_C5_Flipbook
P. 72
Or
Right-click and choose Delete option from the
context menu.
A Delete dialog box with four options appears. a 4
b
a. Shift cells left: deletes the selected cells and
shifts the cells on the right to left. c
d
b. Shift cells up: deletes the selected cells. The cells
below shift up. 5
c. Entire row: deletes the selected row. The row
below shifts up.
d. Entire column: deletes the selected column and shifts
the column on the right to left.
Step 4: Click on the radio button before Shift cells left option.
Step 5: Click on Ok button.
The selected cells are deleted and the cells on the right move to the left. In the given screenshot,
the cells have moved from column C to column B.
Deleting an Entire Row or Column
To delete an entire row or column follow the given steps:
Step 1: Click on the row or column header of the row or column you have to delete.
2
3
4
1
Step 2: Click on Home tab.
Step 3: Click on Delete drop down menu in
Cells group. A list of options appears.
Step 4: Select the Delete Sheet Rows or Delete
Sheet Columns.
The selected row or column is deleted. The row below or the column on the right shifts to fill
the space.
70 Premium Edition-V

