![how to clear formatting in excel 2016 how to clear formatting in excel 2016](http://indiaexcel.com/wp-content/uploads/2016/10/Clear-buttons-description-Alignment-group-MS-Excel-2016.png)
Click on the cell (or click and drag on the cells) you want to apply the formatting.In the Clipboard group of the Home ribbon, click on the Format Painter button.Select the cell that contains the formatting you want to copy.This feature allows you to copy the formatting from one part of your workbook to another. Go to the Alignment Group on the Home Tab.It is useful if you have text that is too wide for the cell. This feature helps you add more text in the cell by increasing its height but keeping its width. Choose the first option – General (No Specific Format).Select the cell/s you want to clear the format.It has shortcuts for a particular number format, like adding currency – which could be GBP, Dollars or the Euro symbol, formatting a number as a percentage, adding a thousand separator or increasing/ decreasing decimals. Number group allows formatting of your figures. You can also change the direction of text in a cell/s by simply selecting the cell/s to change and then choose the orientation you need. Click on the cell/s you want to format.This group indicates where your text/numbers will line up in a cell. Click on the Dialog box launcher arrow.You can also make your contents be boldfaced, italicized or underlined in just a click.įor more detailed changes, you can explore the font settings by following the steps below. Note: Changing the font size is also possible just by clicking the “grow and shrink font” button, enclosed in green. Select the font style or font size you require.Click on the drop down arrow next to the font style (red) or font size (blue) box.Go to Home Ribbon and look for the Font Group.Using the font group, you will be able to change the font style and size of the contents of your cell. This group contains the main features for changing the appearance of your content, as shown below. The Main Groups in Excel 2016 Home Ribbon 1. This portion contains mostly of formatting and editing tools. The Home Ribbon to customize and format cells and worksheetsĮxcel 2016 consists of several ribbons that make you do complicated tasks in just few clicks. Uniformity will even encourage you to work on your file with enthusiasm and excitement. Doing so will make your file look more organized and professional. However, formatting your worksheets is not a difficult task at all. We ignore the format, most especially when we are working with lots of information in a worksheet. More often, we tend to disregard the styles we use, for instance fonts, no matter how different they are from each other. To clear strikethrough formatting, just clear the checkbox in the Format Cells dialog box.Creativity and uniformity are few of the least aspects most people consider in using Excel. If you'd like to apply strikethrough to just part of a cell, select the text you'd like to format in the formula bar, or, in the cell itself. If you'd like to apply strikethrough formatting to the entire contents of a cell, just select the cell, access the Format Cells dialog, and check the Strikethrough box. The process for applying strikethrough formatting is similar. To remove superscript or subscript formatting, select the cell, and then access the Format Cells dialog box. However, when you edit a cell directly you will see the formatting clearly. Note that the formula bar doesn't show any indication that superscript or subscript formatting has been applied. Then use Format Cells to apply Superscript or Subscript as you like. As before, carefully select the text you'd like to format. The second option is to select a cell and work directly in the formula bar. On the Font tab, check the format you want, and press OK to confirm. Then, select the text you'd like to format and access the Format Cells dialog box. The first option is to double-click a cell, or select the cell and press F2 to enter edit mode.
![how to clear formatting in excel 2016 how to clear formatting in excel 2016](https://media.gcflearnfree.org/content/56337061927faf14d04cade7_10_30_2015/conditional_formatting_remove_result.png)
There are two ways to apply subscript or superscript. If you do, you'll see that all text in a cell is affected, which is almost certainly not what you want. You can't just select a cell normally and apply one of these formats. To apply either subscript or superscript, you need to follow a particular process. Instead, they're located on the Font tab of the Format Cells dialog box in the Effects group. If you need to apply subscript or superscript formatting, you won't find these options on the ribbon.
How to clear formatting in excel 2016 how to#
In this lesson we'll look at how to apply subscript, superscript, and strikethrough formatting.