100 WPS Spreadsheet Shortcuts (Windows & Mac)

WPS Spreadsheet power users live on the keyboard. This curated list gives you 100 high‑value shortcuts grouped by workflow, with Windows and macOS variants side‑by‑side. Where WPS Academy explicitly documents a shortcut, you’ll see [Official]; if it’s common in Excel but not confirmed by WPS Academy, we flag [Unverified in WPS Academy]. For Mac variants that aren’t documented, we add [Verify on macOS].

Tip for Mac users: some function keys may require holding Fn depending on system settings.

How we verified (and how to read this list)

• We prioritized WPS Academy tutorials from 2023–2025 for authoritative confirmation, including the consolidated reference in “Common shortcut keys in WPS Spreadsheet” (2023) and topic‑specific lessons like date/time insert, filter toggle, absolute references, AutoSum, and Go To. See: WPS Academy — Common shortcut keys in WPS Spreadsheet (2023), WPS Academy — Quick access to insert date and time (2023), WPS Academy — How to filter blanks or non‑blanks with one click (2023), WPS Academy — How to use absolute cell reference (2023), WPS Academy — How to use the SUM function (2023), and WPS Academy — How to delete blank cells (Go To Special) (2023).
• If a shortcut is widely used in Excel but not shown in WPS Academy’s Spreadsheet docs, we keep it with a caution label so you can test in your build.
• Format: Action — Windows | Mac — Notes

Navigation & Selection

1. Move to first cell (A1) — Ctrl+Home | Cmd+Home — [Official]
2. Move to last used cell — Ctrl+End | Cmd+End — [Official]
3. New line within a cell — Alt+Enter | Option+Enter — [Official]
4. Move one screen down — Page Down | Fn+Down — [Unverified in WPS Academy]
5. Move one screen up — Page Up | Fn+Up — [Unverified in WPS Academy]
6. Move to row start — Home | Fn+Left — [Unverified in WPS Academy]
7. Move to row end — End | Fn+Right — [Unverified in WPS Academy]
8. Jump to edge of data region — Ctrl+Arrow | Cmd+Arrow — [Unverified in WPS Academy]
9. Extend selection to edge — Ctrl+Shift+Arrow | Cmd+Shift+Arrow — [Unverified in WPS Academy]
10. Select entire worksheet — Ctrl+A (twice) | Cmd+A (twice) — [Unverified in WPS Academy]
11. Select current region — Ctrl+Shift+* | Cmd+Shift+* — [Unverified in WPS Academy]
12. Select entire row — Shift+Space | Shift+Space — [Unverified in WPS Academy]
13. Select entire column — Ctrl+Space | Cmd+Space — [Unverified in WPS Academy; may conflict with macOS Spotlight]
14. Add to selection — Ctrl+Click | Cmd+Click — [Unverified in WPS Academy]
15. Collapse selection to active cell — Shift+Backspace | Shift+Delete — [Unverified in WPS Academy]

Editing & Clipboard

16. Copy — Ctrl+C | Cmd+C — [Official]
17. Cut — Ctrl+X | Cmd+X — [Official]
18. Paste — Ctrl+V | Cmd+V — [Official]
19. Undo — Ctrl+Z | Cmd+Z — [Official]
20. Redo — Ctrl+Y | Cmd+Y — [Official; on Mac also Cmd+Shift+Z in some layouts]
21. Enter cell edit mode — F2 | F2 (Fn+F2) — [Official]
22. Confirm entry / move down — Enter | Return — [Official]
23. Insert current date — Ctrl+; | Cmd+; — [Official]
24. Insert current time — Ctrl+' | Cmd+' — [Official]
25. Open context menu — Shift+F10 | Shift+Fn+F10 — [Official]
26. Cancel entry — Esc | Esc — [Unverified in WPS Academy]
27. Repeat last action — F4 | F4 (Fn+F4) — [Unverified in WPS Academy for repeat; see 55 for reference toggle]

Fill & Series

28. Fill Down — Ctrl+D | Cmd+D — [Official]
29. Fill Right — Ctrl+R | Cmd+R — [Official]
30. Fill series via handle (keyboard assist) — Shift+Arrow then Ctrl+D/R | Shift+Arrow then Cmd+D/R — [Unverified in WPS Academy]
31. Copy formula from cell above — Ctrl+' (quote) | Cmd+' — [Unverified in WPS Academy]
32. Copy value from cell above — Ctrl+Shift+' | Cmd+Shift+' — [Unverified in WPS Academy]
33. Flash Fill (if available) — Ctrl+E | Cmd+E — [Unverified in WPS Academy]
34. AutoFill without formatting — Ctrl+Drag Alt modifier | Cmd+Drag Option — [Unverified in WPS Academy]
35. Fill Down keeping references — Ctrl+D after selection | Cmd+D — [Official]

Find, Replace & Go To

36. Find — Ctrl+F | Cmd+F — [Official]
37. Replace — Ctrl+H | Cmd+H — [Official]
38. Go To — Ctrl+G | Cmd+G — [Official]
39. Go To Special: Blanks (via dialog) — Ctrl+G, then Alt+S, then K — | Use dialog — [Official via dialog path]
40. Find next — Shift+F4 | Shift+F4 (Fn) — [Unverified in WPS Academy]
41. Close Find/Replace — Esc | Esc — [Unverified in WPS Academy]
42. Navigate to name box — Ctrl+L or F5 (varies) | Cmd+L — [Unverified in WPS Academy]

Rows, Columns & Cells

43. Insert rows (dialog/menu accelerator) — Ctrl+Shift+“+” | Cmd+Shift+“+” — [Unverified in WPS Academy]
44. Delete rows — Ctrl+“−” | Cmd+“−” — [Unverified in WPS Academy]
45. Insert columns — Ctrl+Shift+“+” after selecting column | Cmd+Shift+“+” — [Unverified in WPS Academy]
46. Delete columns — Ctrl+“−” after selecting column | Cmd+“−” — [Unverified in WPS Academy]
47. Hide row — Ctrl+9 | Cmd+9 — [Unverified in WPS Academy]
48. Unhide rows — Ctrl+Shift+9 | Cmd+Shift+9 — [Unverified in WPS Academy]
49. Hide column — Ctrl+0 | Cmd+0 — [Unverified in WPS Academy]
50. Unhide columns — Ctrl+Shift+0 | Cmd+Shift+0 — [Unverified in WPS Academy]
51. Insert new line in same cell — Alt+Enter | Option+Enter — [Official]
52. Clear contents — Delete | Delete — [Unverified in WPS Academy]
53. Open Insert dialog — Ctrl+Shift+“+” | Cmd+Shift+“+” — [Unverified in WPS Academy]
54. Open Delete dialog — Ctrl+“−” | Cmd+“−” — [Unverified in WPS Academy]

Worksheets & Workbooks

55. Toggle absolute/relative reference (in formula edit) — F4 | F4 (Fn+F4) — [Official]
56. Next worksheet tab — Ctrl+Page Down | Option+Cmd+Right — [Unverified in WPS Academy]
57. Previous worksheet tab — Ctrl+Page Up | Option+Cmd+Left — [Unverified in WPS Academy]
58. New workbook — Ctrl+N | Cmd+N — [Official]
59. Open workbook — Ctrl+O | Cmd+O — [Official]
60. Save — Ctrl+S | Cmd+S — [Official]
61. Save As — F12 | Cmd+Shift+S — [Official (F12 on Windows)]
62. Print — Ctrl+P | Cmd+P — [Official]
63. Close workbook — Ctrl+W | Cmd+W — [Official]

Data (Filter, Sort, Tables)

64. Toggle AutoFilter — Ctrl+Shift+L | Cmd+Shift+L — [Official; Verify on macOS]
65. Open filter dropdown (selected header) — Alt+Down | Option+Down — [Unverified in WPS Academy]
66. Apply filter OK — Enter | Return — [Unverified in WPS Academy]
67. Clear filter from column — Alt+C in dropdown | Use menu — [Unverified in WPS Academy]
68. Sort ascending (from dropdown) — A after opening menu | Use menu — [Unverified in WPS Academy]
69. Sort descending (from dropdown) — Z after opening menu | Use menu — [Unverified in WPS Academy]
70. Reapply filter — Ctrl+Alt+L | Cmd+Option+L — [Unverified in WPS Academy]
71. Create table from range — Ctrl+T | Cmd+T — [Unverified in WPS Academy]
72. Insert PivotTable (if available) — Alt+N, V (Windows menu sequence) | Use menu — [Unverified in WPS Academy]
73. Remove duplicates (dialog) — Alt+A, M (Windows sequence) | Use menu — [Unverified in WPS Academy]

Formulas & Calculation

74. AutoSum — Alt+= | Cmd+= (or Cmd+Shift+T) — [Official; Verify on macOS]
75. Enter array formula (legacy) — Ctrl+Shift+Enter | Cmd+Shift+Enter — [Unverified in WPS Academy]
76. Toggle formula view — Ctrl+ | Cmd+ — [Unverified in WPS Academy]
77. Recalculate — F9 | F9 (Fn+F9) — [Official]
78. Calculate active worksheet — Shift+F9 | Shift+F9 — [Unverified in WPS Academy]
79. Insert function dialog — Shift+F3 | Shift+F3 — [Unverified in WPS Academy]
80. Cycle through function arguments — Ctrl+A in formula | Cmd+A — [Unverified in WPS Academy]
81. Complete function with parentheses — Ctrl+Shift+A | Cmd+Shift+A — [Unverified in WPS Academy]
82. Insert reference from selected cells — F4 after selection | F4 — [Official for ref toggle; selection behavior may vary]
83. Jump to precedent (select) — Ctrl+[ | Cmd+[ — [Unverified in WPS Academy]

Formatting & Number Formats

84. Bold — Ctrl+B | Cmd+B — [Official]
85. Italic — Ctrl+I | Cmd+I — [Official]
86. Underline — Ctrl+U | Cmd+U — [Official]
87. Open Format Cells — Ctrl+1 | Cmd+1 — [Unverified in WPS Academy]
88. Apply General format — Ctrl+Shift+~ | Cmd+Shift+~ — [Unverified in WPS Academy]
89. Apply Currency format — Ctrl+Shift+4 | Cmd+Shift+4 — [Unverified in WPS Academy]
90. Apply Percentage format — Ctrl+Shift+5 | Cmd+Shift+5 — [Unverified in WPS Academy]
91. Apply Date format — Ctrl+Shift+3 | Cmd+Shift+3 — [Unverified in WPS Academy]
92. Apply Time format — Ctrl+Shift+2 | Cmd+Shift+2 — [Unverified in WPS Academy]
93. Increase font size — Ctrl+Shift+> | Cmd+Shift+> — [Unverified in WPS Academy]

View & Print

94. Freeze Panes (menu path) — Alt sequence or ribbon/menu | Menu path: Home > Freeze Panes — [Official via menu; no dedicated key]
95. Zoom in — Ctrl+Plus or Ctrl+Mouse Wheel Up | Cmd+Plus or Cmd+Mouse Wheel Up — [Unverified in WPS Academy]
96. Zoom out — Ctrl+Minus or Ctrl+Mouse Wheel Down | Cmd+Minus or Cmd+Mouse Wheel Down — [Unverified in WPS Academy]
97. 100% zoom — Ctrl+0 (numpad 0 on some layouts) | Cmd+0 — [Unverified in WPS Academy]
98. Print preview — Ctrl+P, then preview — | Cmd+P — [Official]
99. Full screen toggle — F11 | Ctrl+Cmd+F — [Unverified in WPS Academy]
100. Show/Hide gridlines (menu path) — Alt sequence or menu | Use View menu — [Unverified in WPS Academy]

Notes, tips, and conflicts to watch

• Mac verification: Many Mac variants follow Cmd for Ctrl, but WPS Academy’s Spreadsheet docs are Windows‑first. Test key areas you rely on most, especially sheet switching and number‑format shortcuts.
• Function keys on Mac: If F2/F4/F9 don’t work, enable “Use F1, F2, etc. keys as standard function keys” in macOS Keyboard settings or hold Fn.
• Selection conflicts: Cmd+Space triggers Spotlight by default on macOS; reassign Spotlight or use menu paths when selecting columns.
• Filters and sorting: The filter toggle is documented; deeper filter menu navigation keys are less standardized. When in doubt, use the ribbon/menu path or the filter dropdown with Tab/Arrow/Enter.
• Freeze panes: WPS Academy documents the feature via menus rather than a dedicated shortcut. Consider recording a quick macro if you use it often.

References (key official pages used)

• According to the WPS Academy summary “Common shortcut keys in WPS Spreadsheet” (2023), core actions like New, Open, Save, Print, Undo/Redo, Copy/Cut/Paste, Edit cell (F2), date/time insert, and navigation basics are supported: WPS Academy — Common shortcut keys in WPS Spreadsheet.
• WPS Academy’s “Quick access to insert date and time into a sheet” (2023) confirms Ctrl+; and Ctrl+' for date/time: WPS Academy — Quick access to insert date and time.
• For filters, the 2023 tutorial shows Ctrl+Shift+L to toggle AutoFilter: WPS Academy — How to filter blanks or non‑blanks with one click.
• The absolute reference toggle during formula editing is documented with F4 in WPS Academy (2023): WPS Academy — How to use absolute cell reference.
• AutoSum insertion via Alt+= appears in WPS Academy’s SUM tutorials (2023): WPS Academy — How to use the SUM function.
• Go To/Go To Special usage is shown in a WPS Academy cleanup workflow (2023): WPS Academy — How to delete blank cells in WPS Spreadsheet.