Page 35 - 2611_SmartGPT Pro V(5.0) C-5

Alternatively, select the cell and press the Delete key.

Fill in the blanks.
uiz Bee a. _________ command reverses any action performed by us.
b. _________ option reverses back the action performed using the

Undo option.

DELETING CELLS, ROWS OR COLUMNS

We can delete unwanted rows and columns from our worksheet. To delete any rows or
columns, follow the given steps:

2 Choose Delete option.

Short key
2 Choose To delete a row or
column:
Delete option.

1 Select a column to be 1 Select a row to be deleted Ctrl + –
deleted and right-click on it. and right-click on it.

INSERTING CELLS, ROWS OR COLUMNS

We can insert cells, rows and columns in Excel 2021.

INSERTING ROWS
To insert a row in the worksheet, follow the given steps:

1 Right-click on the row or
column number above or below
where you want to add a new
row and select Insert option.

A new row will be inserted above the selected row.

Alternatively, click on the down arrow of the Insert option present in the Cells group under
the Home tab, and select the Insert Sheet Rows option from the drop-down list.

Excel 2021 33