Basic text and cell formatting

Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font colour, style, size, text alignment in a cell, or apply formatting effects.

All cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. You can also apply number formatting to tell Excel exactly what type of data you’re using in the workbook, such as percentages (%), currency ($), and so on.

If you want text or numbers in a cell to appear bold, italic, or have a single or double underline, select the cell and on the Home tab, pick the format you want:

Change font style, size, color, or apply effects

Click Home and:

• For a different font style, click the arrow next to the default font Calibri and pick the style you want.
• To increase or decrease the font size, click the arrow next to the default size 11 and pick another text size.