Ready to Checkout?

shopping-cart

Try the Excel Course for Free!

Remove Cell Formatting in Excel – Instructions

by / Thursday, 18 January 2018 / Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365

Remove Cell Formatting in Excel: Overview

            You can remove cell formatting in Excel to clear all the currently applied cell formatting. Removing cell formatting is also called clearing cell formatting. Doing this lets you remove cell formatting that causes problems from selected cells. The contents of the cell are not affected by removing the cell formatting. Later, you can then reapply the desired formatting to the cells to ensure they appear the way you like. This lets you correct issues with cell value display that arises from improper cell formatting, but keep the cell contents.

            You can clear all of the formatting from selected cells by first selecting the cells from which you want to remove all of the formatting. Then click the “Home” tab in the Ribbon. Then click the “Clear” button in the “Editing” button group. Finally, select the “Clear Formats” command from the drop-down menu that appears. Doing this then removes any and all previously applied cell formatting from the selected cells. You can then reformat the selected cells to fix their cell values displays, as desired.

Remove Cell Formatting in Excel - Instructions: A picture of a user clearing cell formatting from selected cells in an Excel workbook.

Remove Cell Formatting in Excel – Instructions: A picture of a user clearing cell formatting from selected cells in an Excel workbook.

Remove Cell Formatting in Excel: Instructions

  1. To remove cell formatting in Excel, select the cells from which you want to remove all of the formatting.
  2. Then click the “Home” tab in the Ribbon.
  3. Then click the “Clear” button in the “Editing” button group.
  4. Finally, select the “Clear Formats” command from the drop-down menu that appears.

Remove Cell Formatting in Excel: Video Lesson

            The following video lesson, titled “Clearing All Formatting from Cells,” shows how to remove cell formatting in Excel. This video lesson on how to clear cell formatting in Excel is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2016-2013.”

TOP