Remove Cell Formatting in Excel – Instructions

Remove Cell Formatting in Excel: Video Lesson

            This 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.2019 and 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. When you remove cell formatting in Excel, it does not affect the contents of the cells. 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

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.