WPS Spreadsheets Keyboard Shortcuts

WPS Spreadsheets is a versatile spreadsheet application providing tools for data analysis, visualization, and formatting. Learning keyboard shortcuts boosts efficiency, enabling quick navigation, editing, and advanced spreadsheet functionalities.

Official URL: https://www.wps.com/spreadsheets

Move one cell in the direction of the arrow

Arrow Keys

Move to the first cell in the sheet

⌘+Fn+Left Arrow

Move to the last cell in the sheet with data

⌘+Fn+Right Arrow

Move up one screen

Fn+Up Arrow

Move down one screen

Fn+Down Arrow

Data Editing

Edit the active cell

Ctrl+U

Copy the selected data

⌘+C

Paste data

⌘+V

Cut the selected data

⌘+X

Undo the last action

⌘+Z

Redo the last undone action

⌘+Y

Formatting

Apply bold formatting

⌘+B

Apply italic formatting

⌘+I

Underline selected text

⌘+U

Open the format cells dialog

⌘+1

Formulas

Start a formula in the active cell

=

Toggle formula view

⌘+`

Open the insert function dialog

Shift+Fn+F3

Auto-sum selected range

⌥+=

File Management

Create a new spreadsheet

⌘+N

Open an existing spreadsheet

⌘+O

Save the current spreadsheet

⌘+S

Print the spreadsheet

⌘+P