Question

write the steps to delete data from worksheet and active cell​

Answer 1

Answer:

If you want to remove cells from the worksheet and shift the surrounding cells to fill the space, you can select the cells and delete them. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Cells.

Answer 2

Answer:

Clearing cell contents

Clearing cells just deletes or empties the cell’s contents without removing the cell from the worksheet, which would alter the layout of surrounding cells. To get rid of just the contents of a cell selection, select the range of cells to be cleared and press the Delete key.

If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, follow these steps:

Select the cells containing the content you want to clear.

Click the Clear button (the one with the eraser) in the Editing group on the Home tab.

Click one of the following options on the Clear drop-down menu:

Clear All gets rid of all formatting, comments, and entries in the cell selection.

Clear Formats deletes only the formatting from the cell selection without touching anything else.

Clear Contents deletes only the cell entries; just like pressing the Delete key.

Clear Comments removes the comments in the cell selection but leaves everything else intact.

Clear Hyperlinks removes the active hyperlinks in the cell selection but leaves their descriptive text.