HomeHow ToHow to Clear or Remove Cell Formatting in Microsoft Excel

How to Clear or Remove Cell Formatting in Microsoft Excel

Author

Date

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.

How-to-Compare-Two-Columns-for-Duplicate-or-Unique-Excel-Data
Photo credit: Unsplash

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.

Related

More From

How to Enable, Add & Request Read Receipts in Microsoft Outlook

Sending an email gets your messages across to your recipients in real-time. If you are in a rush to receive a response, an email...

Quick Fix for Netflix Error Code NW-3-6

Netflix has become a reliable streaming service mostly watched by many people worldwide. With more original shows and wide library collection, it is no...

How to Create, Add, Use or Delete Bookmarks on Microsoft Word Documents

When reading a book, it is helpful to have a bookmark on hand to mark the pages where you left off. Did you know...

How to Add Individual User Profiles on Amazon Prime Video

Finally, Amazon is adding individual user profiles to Amazon Prime Video. This feature has been a cornerstone of streaming service platforms like Netflix, Disney...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending