For making the Excel worksheet looks more striking and beautiful, you may apply various formatting to the cells or part of cell content in cells as right screenshot shown. But, sometimes you may not need any cell formatting, and be required to remove all of cell formatting, how can you de...
The next method you can use to remove formatting in your Excel workbook is using the Format Painter tool. It is a handy tool in Excel that lets you apply the same formatting to selected cells as some other cells. You can apply the same color, font style, font size, border style, etc....
You can also copy-paste formatting from one cell/range to the other. Or, you can choose to clear the formatting from cells that contain a specific value or a specific format. In this short Excel tutorial, I will show you how to quickly remove cell formatting in Excel (and some other co...
If you wish to clear format cells in Excel directly by choosing specific cells, you can follow the steps below: Note:For this method, we’ll be using a table where certain cells have a blue background fill. So, the steps will follow through to remove formatting from those cells. 1. In...
Remove date format from cells by Clear Formats feature TheClear Formatsfeature is the most common way to remove format from cells in Excel. Of course, it supports to remove all kinds of date formats. Select the date cells that you will remove date formats from, and clickHome>Clear>Clear Fo...
To clear formats innon-adjacent cells or ranges, select the first cell or range, press and hold theCTRLkey while selecting other cells or ranges. How to make the Clear Formats option accessible in a click If you want to have a one-click tool to remove formatting in Excel, you can add ...
Step 1: Open your desired Excel Sheet or Workbook. Step 2: Click any of the cells in the table and navigate to the Table Design tab. In the Table Styles section, click the down arrow next to preformatted tables to expand the section. Step 3: Click the Clear button to remove the tab...
If you have only some words or characters colored in the cells then Excel can’t remove that color formatting using any of the above steps described. Clear Formatting Using Format Painter First, go to any unformatted cell. After that, go to the “Home” tab and under the Clipboard group,...
Using a VBA Code to Remove Conditional FormattingExcel does not provide an option to remove conditional formatting from the entire workbook. You can use the below VBA code for this.Sub ClearCF()Dim mySheet As WorksheetFor Each mySheet In ThisWorkbook.SheetsmySheet.Cells.FormatConditions.DeleteNext...
How to remove format as table in Excel (convert table to range) In case you no longer need data formatted as a table, here's how you can remove a table format and turn it into a regular range of cells: Right-click any cell in your table. ...