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 can we change the font in a cell

Uploaded time: August 27, 2021 Difficulty Beginner

How can we change the font in a cell

How can we change the font in a cell

When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell?

In this spreadsheet, select a range of cells. In theHome tab, we can change text settings includingSizeandText Color, and add effects for the texts such as Bold, Italic, Fonts, Underline, etc.

1. Select the cells filled withWPS Academy.

2. Right-click the cells, and chooseFormat cellsin the pop-up menu. Or we can just select the cells and press the shortcutCtrl+1.

3. Click the Fonttab in the dialog boxFormat Cells, we can change the font settings mentioned above, and addEffectsfor the contents.

Effectssettings include Strikethrough, Superscript, and Subscript.

We can see the font effects inPreview. ClickOK. The final font effect will be adopted in the selected cells.

To be office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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