Written by 12:22 pm Tech Views: 28

How To Clear Formatting in Excel? 2 Easy Steps

how to clear formatting in excel

If you’ve ever had a cell or group of cells in Excel that’s turned into an unreadable mess, you’ll know that clearing formatting is an essential part of the process.

It can help solve many other issues as well—like making sure everything looks right when printed—so it should be your first step whenever anything goes wrong with your work.

How to clear formatting in Excel Sheet?

Here is the step-wise guide for your understanding. For instance, you can see the below picture, which is formatted because I have copied a table from Google and pasted it on my spreadsheet as it is:

How to clear formatting in Excel Sheet

Here are the easy steps to follow:

Select a cell or group of cells to format:

To select a single cell, click on it with your mouse pointer. To select a range of cells (a contiguous set of cells), hold down the CTRL key while clicking on the first cell in that range and then drag across all of them with your mouse pointer. You can also hold down both the SHIFT and CTRL keys as you click once on each start point; this will create an inclusive selection where all following clicks will be added to that selection until you release either the shift or control keys.

Click on the format option and Select Clear Formatting:

format button

At the top of the sheet, you will find some menus like view, file, edit, insert, etc. Here, you will find the “Format” option. Click on the option, and you will see all the settings of Formatting, as you can see below:

spreadsheet screenshot

You will see the “Clear Formatting” option in the last of the format menu. Now, you have to select all the tabs on which you want to clear formatting and then click on the Clear Formatting button.


Clear formatting in Excel is a very simple process that you can do with little effort on your part. The best part is that it doesn’t require any special skills or knowledge of how to use Excel but instead relies solely on the power of your brain and some common sense!

Clear formatting in Excel involves using one simple command: clear formats. This command will remove all formatting from cells in your workbook, including borders, borders around tables, and headers/footers for each cell (if applicable).

Excel is a great tool for formatting and creating documents, but it can be frustrating at times. With the right tips, though, it’s possible to get your work looking as good as new!

(Visited 28 times, 1 visits today)