• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Clear Formats in Excel

October 17, 2021 by Andrew Childress
How to clear formats in Excel

When you work in Excel, you may find yourself using data in a variety of formats. Let’s learn how to use Clear Formats in Microsoft Excel.

When you work in Excel, you may find yourself using data in a variety of formats. This is especially true if you’ve had information shared with you by others who have applied their own formatting. It can be useful to remove formatting so that data values have a consistent look and feel. Fortunately, this is easy to do. Let’s learn how to use Clear Formats in Microsoft Excel.

How to Use Clear Formats in Excel

Imagine that you have several cells containing data inside your Excel spreadsheet. But they have a variety of formats. As you can see, one cell has bold, italics, and a yellow fill. Another has red text colors. The last cell is formatted in Percent Style. While individually these formats are great, they don’t work well together. They’re distracting and make your sheet look messy.

Clear Formats Excel

Fortunately, you can quickly clear formats to deliver a consistent look and feel to your sheets. To do so, begin by clicking and dragging your cursor to select the range of cells that you want to edit. Here, the range is D4:D6.

Then, go to the Home tab. You’ll find this on Excel’s ribbon, the series of menu tabs across the top of your screen. Over on the right side of the Home tab, you’ll see a dropdown menu that looks like an eraser. Click here.

Clear formats in Excel

This is the Clear dropdown, and you’ll see an array of options listed on it. These include Clear All, Clear Contents, Clear Formats, and more. In this case, you’ll want to use Clear Formats. Go ahead and click on it.

How to clear formats in Excel

Excel will instantly remove all formatting from the selected cells. This is a quick and easy way to bring a cleaner, consistent look to the data in your spreadsheets. Try it out next time you need to remove formatting in a flash.

Category: Excel Functions

About Andrew Childress

Previous Post:Convert Arabic numbers to English in ExcelHow to Convert Arabic Numbers to English in Excel
Next Post:How to Calculate Derived Importance in ExcelDerived importance Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top