How to delete cells in Excel
Do you need to delete a content, format, or just want to delete the comment of a cell in Excel? Today Dexterity Software will guide you how to delete cells in Excel offline.
How to delete cells in Excel Picture 1
For example, you have the following data table:
How to delete cells in Excel Picture 2
Cell E5 contains the content (formulas and data), format (number format and border), accompanying comments (Software Tips) and a link (link) to another file.
Delete the entire cell
To delete the entire contents, formatting, comments and links of a cell, follow these steps:
Step 1: You select the cell to be deleted. In the example above, cell E5.
Note, you can select a range of data or select a row / column in a spreadsheet.
Step 2: On the Home tab (1) , click on the Clear icon (2) . Select Clear All (3) to delete all contents of the cell.
How to delete cells in Excel Picture 3
The result is that all contents, formatting and notes of the cell have been deleted.
How to delete cells in Excel Picture 4
Note: To delete entire cells, you can use the Delete tool in Cells. However, if you use the unfiltered Delete tool, the data of columns and rows after the delete cell will be changed. So Ad encourages you to use the Clear tool to delete data for a cell or a range of data.
Only delete the contents / formatting / notes / links of the cell
The Clear tool is superior to Delete in that it allows users to choose to delete only one of the following points of the cell: content / format / notes / links.
- To delete the formatting applied to selected cells: in Step 2 , instead of selecting Clear All , select Clear Formats .
How to delete cells in Excel Picture 5
- To delete the content that is applied to the selected cells, select Clear Contents .
How to delete cells in Excel Picture 6
- To delete notes applied to the selected cells, select Clear Comments .
How to delete cells in Excel Picture 7
- To remove hyperlinks applied to selected cells, select Clear Hyperlinks.
How to delete cells in Excel Picture 8
Note:
- To delete the contents of a cell without changing its format, notes, and links, you can select the cell to be deleted, and press the Delete or Backspace button on the keyboard.
- To delete comments from a cell or range, select the cell or range to delete, right-click and select Delete comment .
How to delete cells in Excel Picture 9
- To remove links, right-click the area to delete and select Remove Hyperlink .
How to delete cells in Excel Picture 10
Above, Dexterity Software has guided you a number of ways to delete content, notes of cells in Excel. Wish you success!
You should read it
- Merge cells in Excel
- MS Excel 2007 - Lesson 5: Edit Worksheet
- How to color formula cells in Excel automatically
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- 8 How to delete blank rows in ExcelHow to delete blank rows in Excel
- How to split cells, combine cells in Excel
- How to calculate and color blank cells in Excel
- How to delete quick recipe on Excel
- Delete empty data cells in Excel 2007 or 2010
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to Lock Cells in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells