This short tutorial shows a couple of quick ways to remove formatting in Excel worksheets. Show
When working with large Excel worksheets, it's a common practice to apply different formatting options to make data relevant to a particular situation stand out. In other situations, however, you may want to highlight other data, and for this, you will need to remove the current format first. Manually changing cell color, font, borders, alignment and other formats would be tiresome and time-consuming. Luckily, Microsoft Excel provides a couple of quick and simple ways to clear formatting in a worksheet, and I will show you all these techniques in a moment. How to clear all formatting in ExcelThe most obvious way to make a piece of information more noticeable is to change the way it looks. Excessive or improper formatting, however, may have an opposite effect, which makes your Excel worksheet difficult to read. The easiest way to fix this is to remove all current formatting and start embellishing the worksheet from scratch. To remove all formatting in Excel, just do the following:
This will erase all cell formatting (including conditional formatting, number formats, fonts, colors, borders, etc.) but keep the cell contents. Clear Format tipsWith this Excel Clear Formatting feature, you can easily remove formats not only from a single cell, but also from an entire row, column or worksheet.
How to make the Clear Formats option accessible in a clickIf you want to have a one-click tool to remove formatting in Excel, you can add the Clear Formats option to the Quick Access toolbar or Excel ribbon. This might be especially useful if you receive many Excel files from your colleagues or clients and their formatting prevents you from making the data look the way you want. Add the Clear Formats option to Quick Access toolbarIf Clear Formats is one of the most used features in your Excel, you can have it added to the Quick Access Toolbar in the top-left corner of your Excel window: To do this, perform the following steps:
Add the Clear Formats button to the ribbonIf you'd rather not clutter your Quick Access toolbar with too many buttons, you can create a custom group on the Excel ribbon and place the Clear Formats button there. To add the Clear Formats button to the Excel ribbon, follow these steps:
And now, with the new button in place,
you can remove formatting in Excel in a single click! How to remove formatting in Excel using Format PainterI guess everyone knows how to use Format Painter to copy formatting in Excel. But have you ever thought that it can also be used to clear format? All it takes is these 3 quick steps:
That's all there is to it! Note. Neither Clear Formats nor Format Painter can
clear formatting applied to only some part of the cell contents. For example, if you highlighted just one word in a cell with some color, like shown in the screenshot below, such formatting won't be removed: That's how you can quickly remove formatting in Excel. I thank you for reading and hope to see you on our blog next week! You may also be interested inWhich of the following features removes all formatting from selected text?On the Home tab, in the Font group, click Clear All Formatting.
Which tool lets you copy the formatting of one piece of text and apply it to another piece of text?Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the formatting from one object and apply it to another one—think of it as copying and pasting for formatting.
Which of the following features removes all formatting from the selected text all formatting cleared erase all formatting remove all formatting clear all formatting?Using the Clear All Formatting Button. With your text selected, click the Clear All Formatting button, located in the Home tab of the ribbon bar.. Pressing this will remove all of the formatting from your selected text. ... . One thing to note, however. ... . Select the Clear Formatting option.. Which of the following commands quickly removes style formatting from selected text?CTRL-SPACE removes character-level formatting from the selected text (fonts, italics/bold, font size, etc.)
|