Format Cells dialog - Font tab

You use the Font tab of the Format Cells dialog to specify the way in which text in the selected cells in the spreadsheet is displayed.

To access the Format Cells dialog, on the Home tab, click the dialog launcher Dialog launcher in the Font group.

Field Description
Use default

Select this check box to return the font formatting of the text in the selected cells back to the default settings, as specified on the Default Table Fonts dialog, or clear the check box to format the text in the selected cells according to the selections you make in this dialog.

 

Note that this check box only works if you select it having first selected only those cells that have been formatted in a particular way. For example, if you change the font of three particular cells in a column, then subsequently select the entire column and attempt to return the font settings of all its cells back to default, the Use default check box will have no effect. To return the font settings of the three particular cells back to default, you must select precisely those three cells - and no other cells - and select the Use default check box.
Font Specify the font with which to display text in the selected cells.
Font style Specify whether to display text in the selected cells in normal, italic, bold or bold italic.
Size Select the size in which to display text in the selected cells.
Underline Select this check box to underline the text in the selected cells, or clear the check box to remove underlining from the text.
Strike through Select this check box to draw a horizontal line through the text in the selected cells, or clear the check box to remove strikethrough formatting from the text.
Text colour Select the colour in which to display text in the selected cells.

How do I...

Specify the way in which you want text to be displayed in the selected cells using the fields on this tab.

Select the Use default check box.

Related Topics:

Working with dialogs

Formatting spreadsheet cells