Format textual content in cells

Format textual content in cells

Formatting textual content or numbers could make them seem extra seen particularly when you’ve got a big worksheet. Altering default codecs contains issues like altering the font colour, type, dimension, textual content alignment in a cell, or apply formatting results. This text exhibits you how one can apply totally different codecs and likewise undo them.

The font setting buttons on the Ribbon

If you would like textual content or numbers in a cell to look daring, italic, or have a single or double underline, choose the cell and on the Dwelling tab, decide the format you need:

the Font group of buttons for use with changing font style in a cell

Change font type, dimension, colour, or apply results

Click on Dwelling and:

  • For a special font type, click on the arrow subsequent to the default font Calibri and decide the type you need.

  • To extend or lower the font dimension, click on the arrow subsequent to the default dimension 11 and decide one other textual content dimension.


  • To vary the font colour, click on Font Coloration and decide a colour.

  • So as to add a background colour, click on Fill Coloration subsequent to Font Coloration.

    Pick another text color

  • To use strikethrough, superscript, or subscript formatting, click on the Dialog Field Launcher, and choose an choice beneath Results.

    Font dialog box launcher Format dialog box with superscript selected.

Change the textual content alignment

You’ll be able to place the textual content inside a cell in order that it’s centered, aligned left or proper. If it is a lengthy line of textual content, you’ll be able to apply Wrap Textual content so that each one the textual content is seen.

Choose the textual content that you simply wish to align, and on the Dwelling tab, decide the alignment choice you need.

Alignment of text

Clear formatting

For those who change your thoughts after making use of any formatting, to undo it, choose the textual content, and on the Dwelling tab, click on Clear > Clear Codecs.

use the clear format button to remove formatting

Leave a Reply