=================================== WPS Spreadsheets keyboard shortcuts =================================== First published at 12/20/2023 on https://defkey.com/wps-spreadsheets-shortcuts WPS Spreadsheet is a free Excel editor for effortless sheet creation, editing, saving, and sharing. WPS Spreadsheet supports 17 file formats, including .xls, .xlsx, .xlsm, .xlt, .csv, .txt, .pdf and more. WPS Spreadsheets has 65 shortcuts and we have listed all of them below. General ------- Alt + Enter Start a new line in the same cell Alt + F11 Display the Microsoft Visual Basic Editor Alt + F8 Display the Macros dialog box to run, edit or delete macros Alt + Space Display the Control menu for the program window Arrow keys Move one cell up, down, left, or right in a worksheet Backspace Clear the content of the active cell to re-edit cell content Ctrl + ' Enter the current time Ctrl + ; Enter the current date Ctrl + 1 Display the Format Cells dialog box Ctrl + Arrow keys Select the entire worksheet Ctrl + Arrow keys Move to the edge of the current data region in a worksheet Ctrl + B Apply or remove bold formatting Ctrl + C Copy selected cells Ctrl + D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below Ctrl + End Move to the last cell on a worksheet, in the lowest used row of the rightmost used column Ctrl + Enter Fill the selected cell range with the current entry Ctrl + F Display the Find dialog box Ctrl + F1 Display the Task Pane on the right side of the program window Ctrl + G Display the Go To dialog box Ctrl + H Display the Replace dialog box Ctrl + Home Move to the beginning of a worksheet Ctrl + I Apply or remove italic formatting Ctrl + K Display the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks Ctrl + Left click Select multiple ranges of cells Ctrl + N Create a new, blank workbook Ctrl + O Display the Open dialog box to open or find a file Ctrl + P Display the Print dialog box Ctrl + Page Down Switch between worksheet tabs, from right-to-left Ctrl + Page Up Switch between worksheet tabs, from left-to-right Ctrl + R Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right Ctrl + S Save the active file with its current file name, location, and file format Ctrl + Shift + ' Enter the current time Ctrl + Shift + ; Enter the current time Ctrl + Shift + = Displays the Insert dialog box Ctrl + Shift + Arrow keys Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extend the selection to the next nonblank cell Ctrl + Shift + Home Extend the selection of cells to the beginning of the worksheet Ctrl + Shift + Tab Go to previous worksheet tab Ctrl + Tab Go to next worksheet tab Ctrl + U Apply or remove underlining Ctrl + V Insert the contents of the Clipboard at the insertion point and replace any selection Ctrl + W Close the selected workbook window Ctrl + X Cut the selected cells Ctrl + Y Repeat the last command or action, if possible Ctrl + Z Reverse the last command or to delete the last entry you typed Enter Move one cell down in a selected cell range F1 Help F2 Edit the active cell and positions the insertion point at the end of the cell contents F4 Repeat the last action of adding or deleting the whole row/column F7 Display the Spelling dialog box to check spelling in the active worksheet or selected range F9 Calculate all worksheets in all open workbooks F11 Insert chart F12 Display the Save As dialog box to save the file with a different name, type or location Home Move to the cell in the upper-left corner of the window Page Down Select the cells in the next screen in the same column(s) Page Up Select the cells in the previous screen in the same column(s) Shift + Arrow keys Extend the selection of cells by one cell, or row/column in that direction Shift + Enter Move one cell up in a selected cell range Shift + F10 Display context menu for a selected item Shift + Home Extend the selection of cells to the first row of this window in this column Shift + Insert Insert the contents of the Clipboard at the insertion point and replace any selection Shift + Move the mouse Select the area from the active cell to the clicked cell Shift + Page Down Select the cell range from the current cells to the next screen of the same column(s) Shift + Page Up Select the cell range from the current cells to the previous screen of the same column(s) Shift + Tab Move to the previous cell in a worksheet, or moves one cell to the left in a selected range Tab Move one cell to the right in a worksheet Source: WPS Help Center Last modified on (UTC): Wednesday, December 20, 2023 Defkey © All rights reserved.