But have you ever thought that it can also be used to clear format? All it takes is these 3 quick steps:
#How do you remove all text formatting in word how to#
I guess everyone knows how to use Format Painter to copy formatting in Excel. How to remove formatting in Excel using Format Painter
With the New Group selected, click the Rename button, type the name you want, and click OK.Because new commands can only be added to custom groups, click the New Group button:.Right-click anywhere on the ribbon, and select Customize the Ribbon….To add the Clear Formats button to the Excel ribbon, follow these steps: If 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. In the list of commands, scroll down to Clear Formats, select it and click the Add button to move it to the right-hand section.Īdd the Clear Formats button to the ribbon.Under Choose commands from, select All Commands.In your Excel worksheet, click File > Options, and then select Quick Access Toolbar on the left-side pane.If 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: Add the Clear Formats option to Quick Access toolbar
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. If 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. How to make the Clear Formats option accessible in a click
In other situations, however, you may want to highlight other data, and for this, you will need to remove the current format first.
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. This short tutorial shows a couple of quick ways to remove formatting in Excel worksheets.