A lot of users are using cell formatting on their spreadsheets to create a better appearance and format for their data presentation. But, if you receive a worksheet and do not want the customized formatting used, you can remove it.
When you clear cell formats in Microsoft Excel, it will not affect the data included in it. You will only remove the colors, font changes, or cell adjustments. The contents will remain as it is. If ever you change your mind, you can reapply the same formatting on your cells as before.
Ways to Remove Cell Formatting in a Microsoft Excel Worksheet
Clearing a cell formatting takes only a few steps. You have the option to remove the format on selected cells or the entire spreadsheet.
How to Clear Cell Formatting on Microsoft Excel Spreadsheet Using Selected Cells
- Launch the spreadsheet where you want to clear the formatting.
- Look for the cells you want to edit and highlight or select them.
- Go to the main menu and select the Home tab.
- Head over to the Editing section.
- Click the Clear button or the eraser icon.
- Select Clear Formats.
How to Remove Cell Formatting on Microsoft Excel Spreadsheet Using All Cells
If you choose to clear cell formatting on all cells, the steps are similar.
- Open the Excel spreadsheet.
- Highlight all the cells. You can press Ctrl+A for Windows PC or Cmd+A for iOS.
- Go to the main menu and select the Home tab.
- Navigate to the Editing section.
- Click the Clear button or the eraser icon.
- Select Clear Formats.
However, if you choose to clear both the content and the formatting in a cell, you can select Clear All instead of Clear Formats. If you want to remove the contents but retain the formatting, you can click Clear Contents.
Were the methods above helpful for you? We would love to know your thoughts! You can share them with us in the comment section below.
