WPS Features
Resources
Free AI Tools
Docs Center

How to Use WPS Font and Size on macOS

Last updated:July 16, 2026

This how-to guide includes 6 topics for changing font and size in WPS Sheets, with 5 available without membership and 1 membership-related topic, so you can jump directly from the index to the steps you need.

How-to Index

#TopicMembership
11. Set a font from the ribbonFree
22. Set a font size from the ribbonFree
33. Set a font from the right-click menuFree
44. Set a font size from the right-click menuFree
55. Set font and size in the Format Cells dialog boxFree
66. Understand system fonts and cloud fontsMembership-related

How-to Guide

1. Set a font from the ribbon

Entry point: Home tab → Font drop-down menu

  1. Select the cell you want to change, or select text inside the cell.
  2. Click the Font drop-down menu on the Home tab.
  3. Choose the font you want, such as SimSun, Microsoft YaHei, or Arial.
  4. If needed, type the font name directly in the font box to search faster.

Success Criteria

  • UI state: The selected content is displayed in the new font immediately.
  • Next actions: You can continue typing, copy formatting, or save the file.

Tips While Using

  • Common mistakes: If you do not select the target cell first, the change may not apply to the content you intended to edit.

2. Set a font size from the ribbon

Entry point: Home tab → Font Size drop-down menu

  1. Select the cell you want to resize, or select text inside the cell.
  2. Click the Font Size drop-down arrow on the Home tab.
  3. Choose the size you want from the list.
  4. To use a custom value, type a number such as 100 or 400 and press Return to confirm.

Success Criteria

  • UI state: The selected content is shown at the size you selected or entered.
  • Next actions: You can continue adjusting alignment, color, borders, or other formatting.

Tips While Using

  • Common mistakes: If you type a value but do not press Return, the new size will not be applied right away.

3. Set a font from the right-click menu

Entry point: Right-click menu → Font drop-down menu

  1. Select the cell you want to change, or select text inside the cell.
  2. Right-click the selection to open the shortcut menu.
  3. Find the Font drop-down menu in the menu.
  4. Select the target font and confirm the result.

Success Criteria

  • UI state: The text font updates immediately.
  • Next actions: You can continue adjusting other formatting from the right-click menu.

Tips While Using

  • Common mistakes: If you right-click outside the target selection, the current selection range may change.

4. Set a font size from the right-click menu

Entry point: Right-click menu → Font Size drop-down menu

  1. Select the cell you want to resize, or select text inside the cell.
  2. Right-click the selection to open the shortcut menu.
  3. Click the Font Size drop-down menu.
  4. Choose the size you want from the list.

Success Criteria

  • UI state: The text size changes immediately.
  • Next actions: You can continue editing content or save the current spreadsheet.

Tips While Using

  • Common mistakes: If you only want to change part of the text, enter text editing mode inside the cell first and then select the text.

5. Set font and size in the Format Cells dialog box

Entry point: Home tab → font settings arrow icon; or right-click menu → Format Cells → Font

  1. Select the cell you want to change, or select text inside the cell.
  2. Click the font settings arrow icon on the Home tab, or right-click and choose Format Cells.
  3. In the dialog box, switch to the font-related settings area.
  4. Set the font and font size separately.
  5. Click OK to apply the changes.

Success Criteria

  • UI state: Both the font and the font size update according to your settings.
  • Next actions: You can continue setting font style, color, or other cell formatting options.

Tips While Using

  • Common mistakes: If you do not confirm the current selection before editing, you may format a larger range than intended.

6. Understand system fonts and cloud fonts

Entry point: Available font resources in the font list

  1. Open the font drop-down menu to review the available fonts.
  2. Distinguish between system fonts that are ready to use and cloud fonts that may require additional conditions.
  3. Choose the most suitable font for your document purpose.
  4. If a font is unavailable, switch to a local font or review membership options.

Success Criteria

  • UI state: You can identify the source of the fonts currently available in the document.
  • Next actions: You can choose an alternative font or continue with related membership options if needed.

Tips While Using

  • Membership: Some cloud fonts may be related to membership benefits.
  • Environment limits: Cloud font access usually works better with an internet connection.