How to clear a cell in Excel
You can watch a video tutorial here.
Excel is a popular spreadsheet application that has many options for formatting cells. When working with Excel, you may want to modify the sheet by deleting or clearing a cell without affecting the formatting.
Option 1 – Use the Delete button
Step 1 – Select the cell
- Select the cell to be cleared
Step 2 – Press Delete
- Press the Delete button on the keyboard
- The cell is cleared of its contents
Option 2 – Use the menu option
Step 1 – Select the cell
- Select the cell to be cleared
Step 2 – Choose the menu option
- Got to Home > Editing
- Expand the Clear drop-down
- Select Clear Contents
Step 3 – Check the result
- The contents of the cell are cleared
- The formatting remains intact