Kingsoft Spreadsheet Shortcuts (WPS Spreadsheets): Complete List
Kingsoft Spreadsheets is the old name of WPS Spreadsheets, the spreadsheet app inside WPS Office. Its keyboard shortcuts match Microsoft Excel on Windows for almost every common task. Ctrl + C copies, Ctrl + V pastes, Ctrl + D fills down, Ctrl + 1 opens Format Cells, and Alt + Enter starts a new line inside a cell.
This guide lists 71 Windows shortcuts sorted into 8 categories, plus the Mac equivalents. It also corrects several errors that still appear in older Kingsoft shortcut lists, including the official WPS help page.
Top 10 Kingsoft Spreadsheet shortcuts
If you learn only ten shortcuts, learn these. They cover most of the clicking you do in a normal working day.
| Shortcut | What it does |
| Ctrl + C / Ctrl + V | Copy and paste the selected cells |
| Ctrl + Z | Undo the last action |
| Ctrl + S | Save the workbook |
| F2 | Edit the active cell with the cursor at the end |
| Alt + Enter | Start a new line inside the same cell |
| Ctrl + Enter | Fill every selected cell with what you just typed |
| Ctrl + D | Copy the top cell down into the selected cells |
| Ctrl + Arrow key | Jump to the edge of the current data block |
| Ctrl + 1 | Open the Format Cells dialog |
| F4 (while editing a formula) | Switch a cell reference between relative and absolute ($A$1) |
Is Kingsoft Spreadsheets the same as WPS Spreadsheets?
Yes. Kingsoft Office Software sold its office suite as Kingsoft Office, with apps called Kingsoft Writer, Kingsoft Spreadsheets and Kingsoft Presentation. The suite was later renamed WPS Office, and the spreadsheet app became WPS Spreadsheets.
The program, its menus and its shortcuts carried over. Every shortcut in this guide works whether your copy says Kingsoft or WPS. WPS Spreadsheets opens and saves Excel files (.xlsx and .xls) and also uses its own .et format.
WPS Spreadsheets runs on Windows, macOS, Linux, Android and iOS. The tables below are for Windows and Linux keyboards. Mac users can jump to the Mac section.
General and file shortcuts
| Shortcut | What it does |
| Ctrl + N | Create a new blank workbook |
| Ctrl + O | Open an existing file |
| Ctrl + S | Save the active workbook |
| F12 | Open Save As to save with a new name, type or location |
| Ctrl + P | Open the Print dialog |
| Ctrl + W | Close the active workbook window |
| Ctrl + Z | Undo the last action |
| Ctrl + Y | Redo, or repeat the last action |
| F1 | Open Help |
| Ctrl + F1 | Show or hide the task pane on the right |
| Alt + Space | Open the program window’s control menu |
| Alt + Tab | Switch between open windows |
Navigation shortcuts
| Shortcut | What it does |
| Arrow keys | Move one cell up, down, left or right |
| Ctrl + Arrow key | Jump to the edge of the current data region |
| Home | Move to the first cell of the current row |
| Ctrl + Home | Move to cell A1 |
| Ctrl + End | Move to the last used cell (lowest used row, rightmost used column) |
| Page Down | Move one screen down |
| Page Up | Move one screen up |
| Ctrl + Page Down | Go to the next worksheet (the tab to the right) |
| Ctrl + Page Up | Go to the previous worksheet (the tab to the left) |
| Tab | Move one cell to the right |
| Shift + Tab | Move one cell to the left |
| Enter | Move one cell down (inside a selection, stays in the selection) |
| Shift + Enter | Move one cell up |
Selection shortcuts
| Shortcut | What it does |
| Ctrl + A | Select the current data region; press again to select the whole sheet |
| Shift + Arrow key | Extend the selection by one cell |
| Ctrl + Shift + Arrow key | Extend the selection to the last non-blank cell in that direction |
| Ctrl + Shift + Home | Extend the selection to cell A1 |
| Ctrl + Shift + End | Extend the selection to the last used cell |
| Shift + Page Down | Extend the selection one screen down |
| Shift + Page Up | Extend the selection one screen up |
| Ctrl + Space | Select the entire column |
| Shift + Space | Select the entire row (turn off any input method first) |
| Ctrl + click | Add another cell or range to the selection |
| Shift + click | Select everything from the active cell to the clicked cell |
Editing and data entry shortcuts
| Shortcut | What it does |
| F2 | Edit the active cell, cursor at the end |
| Alt + Enter | Start a new line in the same cell |
| Ctrl + Enter | Fill all selected cells with the current entry |
| Ctrl + D | Fill down from the top cell of the selection |
| Ctrl + R | Fill right from the leftmost cell of the selection |
| Ctrl + ; | Insert today’s date |
| Ctrl + Shift + ; | Insert the current time |
| Backspace | Clear the active cell and start typing in it |
| Delete | Clear the contents of the selected cells |
| Esc | Cancel the entry you are typing |
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Shift + Insert | Paste (alternative) |
Formatting shortcuts
| Shortcut | What it does |
| Ctrl + B | Bold on or off |
| Ctrl + I | Italic on or off |
| Ctrl + U | Underline on or off |
| Ctrl + 1 | Open Format Cells (number, alignment, font, border, fill) |
| Ctrl + K | Insert or edit a hyperlink |
Formula shortcuts
| Shortcut | What it does |
| Alt + = | AutoSum the cells above or to the left |
| Shift + F3 | Open the Insert Function dialog |
| F4 (while editing a formula) | Cycle a reference through A1, $A$1, A$1 and$A1 |
| F9 | Recalculate all open workbooks |
Row, column and sheet shortcuts
| Shortcut | What it does |
| Ctrl + Shift + = | Open the Insert dialog (cells, rows or columns) |
| Ctrl + – | Open the Delete dialog (cells, rows or columns) |
| F4 | Repeat the last insert or delete of a whole row or column |
| Ctrl + Shift + L | Turn AutoFilter on or off for the current data |
| F11 | Insert a chart from the selected data |
Dialog box and tool shortcuts
| Shortcut | What it does |
| Ctrl + F | Find |
| Ctrl + H | Find and Replace |
| Ctrl + G | Go To a cell or named range |
| F7 | Spell check the sheet or selection |
| Alt + F8 | Open the Macros dialog to run, edit or delete macros |
| Alt + F11 | Open the VBA editor (only in editions with VBA support) |
| Shift + F10 | Open the right-click menu for the selection |
WPS Spreadsheets shortcuts on Mac
On WPS Office for Mac, swap Ctrl for Command (⌘) in most everyday shortcuts. Function-key shortcuts may need the Fn key on a MacBook keyboard.
| Mac shortcut | Windows equivalent | What it does |
| ⌘ + N | Ctrl + N | New workbook |
| ⌘ + O | Ctrl + O | Open a file |
| ⌘ + S | Ctrl + S | Save |
| ⌘ + P | Ctrl + P | |
| ⌘ + Z | Ctrl + Z | Undo |
| ⌘ + C | Ctrl + C | Copy |
| ⌘ + X | Ctrl + X | Cut |
| ⌘ + V | Ctrl + V | Paste |
| ⌘ + B | Ctrl + B | Bold |
| ⌘ + I | Ctrl + I | Italic |
| ⌘ + U | Ctrl + U | Underline |
| ⌘ + F | Ctrl + F | Find |
Shortcuts that work differently from Excel
WPS Spreadsheets copies Excel’s shortcut layout closely, so most Excel habits transfer. These are the few places to watch.
| Shortcut | In Microsoft Excel | In WPS Spreadsheets |
| Ctrl + ‘ | Copies the formula from the cell above | WPS help lists it as inserting the time; use Ctrl + Shift + ; for time instead |
| Alt (pressed alone) | Shows ribbon KeyTips letters | Ribbon key navigation behaves differently, so Alt-letter sequences from Excel may not match |
| Alt + F11 | Opens the VBA editor | Works only in editions that include VBA support |
| F4 (outside a formula) | Repeats almost any last action | WPS documents it as repeating the last row or column insert or delete |
How to customize shortcuts in WPS Spreadsheets
You can change or add shortcuts if a key you use in Excel behaves differently.
- Click Menu in the top-left corner and choose Options.
- Open Customize Ribbon.
- Click Keyboard shortcuts in the lower-left corner.
- Pick a command, press the new key combination, and confirm.
Download the free PDF cheat sheet
Get all 71 Windows shortcuts and the Mac equivalents on a single printable page.
Download the Kingsoft / WPS Spreadsheet Shortcuts PDF
Frequently asked questions
Is Kingsoft Spreadsheets the same as WPS Spreadsheets?
Yes. Kingsoft Spreadsheets is the former name of WPS Spreadsheets. The app and its shortcuts are the same.
Do Microsoft Excel shortcuts work in WPS Spreadsheets?
Most do. Copy, paste, fill, navigation, selection and Format Cells shortcuts are identical. A few, such as Ctrl + ‘ and Alt-based ribbon keys, behave differently.
What is the shortcut for AutoSum in WPS Spreadsheets?
Alt + =. It inserts a SUM formula for the cells above or to the left.
How do I select the whole sheet?
Press Ctrl + A. If your cursor is inside a data block, press it twice.
How do I insert the current date and time?
Ctrl + ; inserts today’s date. Ctrl + Shift + ; inserts the current time.
Can I change keyboard shortcuts in WPS Spreadsheets?
Yes. Go to Menu, Options, Customize Ribbon, then Keyboard shortcuts.
Do these shortcuts work on Mac?
Most do, with Command (⌘) in place of Ctrl. See the Mac table above.
Do keyboard shortcuts work in WPS Spreadsheets on Android?
Only with a physical keyboard connected, and support is limited to common keys like copy, paste and undo.
Conclusion
Kingsoft Spreadsheets, now WPS Spreadsheets, uses nearly the same shortcuts as Excel, so the time you spend learning them pays off in both programs. Start with the top 10, add one category a week, and keep the PDF next to your keyboard.
Key takeaways
- Kingsoft Spreadsheets and WPS Spreadsheets are the same app with the same shortcuts.
- Ctrl + A selects the sheet; Ctrl + Arrow only jumps to the edge of the data.
- Ctrl + ; inserts the date and Ctrl + Shift + ; inserts the time.
- Alt + = and F4 are the two formula shortcuts that save the most time.
- You can remap any shortcut under Menu, Options, Customize Ribbon.
READ NEXT:
