Feature Summary

Font and font size are the most basic text formatting features in WPS Sheets, supporting quick adjustment of cell text font style and size through multiple methods to meet typesetting needs in different scenarios.

Feature Description

Feature Dimension Description
Membership Restrictions No membership restrictions (cloud fonts require payment)
Version Restrictions No version restrictions

Operation Steps

Setting Font via the Ribbon

Feature Entry
"Home" tab → "Font" dropdown menu

  1. Select the cell or text within the cell that you want to modify the font for
  2. Click the "Font" dropdown menu in the Home tab
  3. Find the desired font in the dropdown list (e.g., SimSun, Microsoft YaHei, Arial, and so on) and click to apply
  4. You can also directly type the font name in the font box for quick search

image

Setting Font Size via the Ribbon

Feature Entry
"Home" tab → "Font Size" dropdown menu

  1. Select the cell or text within the cell that you want to adjust the font size for
  2. Click the dropdown arrow next to the "Font Size" box in the Home tab
  3. Click the desired font size in the list to apply
  4. You can also directly click the "Font Size" box and enter a custom value (e.g., 100, 400), then press Enter to confirm

image

Setting Font via the Right-Click Menu

Feature Entry
Right-click menu → "Font" dropdown menu

  1. Select the cell or text within the cell that you want to modify the font for
  2. Right-click to bring up the context menu
  3. Click the "Font" dropdown menu in the context menu
  4. Find the desired font in the dropdown list (e.g., SimSun, Microsoft YaHei, Arial, and so on) and click to apply

image

Setting Font Size via the Right-Click Menu

Feature Entry
Right-click menu → "Font Size" dropdown menu

  1. Select the cell or text within the cell that you want to adjust the font size for
  2. Right-click to bring up the context menu
  3. Click the "Font Size" dropdown menu in the context menu
  4. Click the desired font size in the list to apply

image

Setting Font and Font Size via the Format Cells Dialog

Feature Entry
"Home" tab → "Font Settings" arrow icon → "Font" menu or "Font Size" menu

  1. Select the cell or text within the cell that you want to modify the font and font size for
  2. Click the "Font Settings" arrow icon in the Home tab
  3. In the pop-up dialog, set the "Font" or "Font Size", and click OK

image

Setting Font and Font Size via Right-Click Format Cells

Feature Entry
Right-click menu → "Format Cells" button → "Font" tab → "Font" menu or "Font Size" menu

  1. Select the target cell, right-click and select the Format Cells button
  2. Switch to the Font tab
  3. Click the "Font" dropdown menu or the "Font Size" dropdown menu
  4. Select the appropriate font and font size, then click OK

image

Increase Font Size Shortcut: Command + Shift + .

Decrease Font Size Shortcut: Command + Shift + ,