WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to change font size, font colour and font style in excel

August 12, 2022

Changing the text's formats is an easy approach to alter your spreadsheet's appearance. A typeface is a collection of letters, numbers, and punctuation marks that have been created to have a similar appearance. There are font size and style options, such as bold and italics.

Below are the steps that tell us more about excel text formats.

How to change fonts in excel online, 2016 and 2019:

A quick and easy approach to improve the aesthetic of your spreadsheet is to change the font.

1.Select the cells that need formatting.

2.On the Home tab, click the Font list arrow.

3.You can also click the Font list arrow on the Mini Toolbar when text is selected in a cell.Decide which typeface to use.

How to apply Bold, Italic, or an Underline in excel:

Other options in the Font group, including Bold, Italic, or Underline, can be used to enhance your project in addition to changing the font type.

1.Choose the text that needs formatting.

2.On the Home tab, select the Bold, Italic, or Underline options.

Shortcuts:Press Ctrl + B to bold.Press Ctrl + I to make text italic.Simply press Ctrl + U to underline.In the Font group, select the Dialog Box Launcher to view more font formatting options. You can modify the underlining style and apply effects from the dialogue box.

How to change font size in excel:

Titles, headers, and body content can all be more easily distinguished by adjusting the font size.

1.Select the cells that need formatting.

2.Click the list's arrow for Font Size.

3.The unit of measurement for font size is points (pt), or 1/72 of an inch. 

4.The font size increases with the number of points.Choose the desired font size.

To change the font size, click the Increase Font Size or Decrease Font Size buttons on the Home tab.

How to change font colour in excel:

Text that has been changed in font colour stands out against the spreadsheet's white background.

1.Select the cells that need formatting.

2.The list's arrow for the font colour.

3.You can also click the Font Color list arrow on the Mini Toolbar when text is selected in a cell.

4.Now select a new colour.

How to format part of a cell in excel:

1.Choose the cell that needs formatting.

2.Select the text you want to format from the formula bar.

3.The text formatting you want to use should be chosen.Now press Enter.

Note: This above written article is an attempt to show you how to change font size, font colour and font style in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                    

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.