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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

More From

Create, Convert, Sign PDF using PDF.New on Google Chrome

There is a lot of something new in store for all users of Google Chrome. With the launching of ".new" PDF shortcuts, users will...

How to Update Firmware or Device Software on Kobo eReader

If you are using the Kobo digital reading device, you will benefit from installing the latest firmware on your device. Kobo offers various types...

How to Get Apple Education Pricing or Student Discounts on MacBook, iPad or iMac

Owning a device comes with a price, most especially if you want to own Apple gizmos. Buying a MacBook, iPad, or an iMac computer...

Create Street View Photos with Just a Phone on Google Maps

Google Maps have created a way for people to navigate around the world through their smartphones. With the images of locations around the world,...

Recent Articles

Stay Connected

Trending