Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close

Keyboard Shortcuts

Working with Spreadsheet
Open 'File' panel Alt+F Open the File panel to save, download, print the current spreadsheet, view its info, create a new spreadsheet or open an existing one, access Spreadsheet Editor help or advanced settings.
Open 'Search' window Ctrl+F Open the Search window to start searching for a cell containing the characters you need.
Open 'Comments' panel* Ctrl+Shift+H Open the Comments panel to add your own comment or reply to other users' comments.
Open comment field* Alt+H Open a data entry field where you can add the text of your comment.
Open 'Chat' panel* Alt+Q Open the Chat panel and send a message.
Save spreadsheet Ctrl+S Save all the changes to the spreadsheet currently edited with Spreadsheet Editor.
Print spreadsheet Ctrl+P Print your spreadsheet with one of the available printers or save it to a file.
Download as Ctrl+Shift+S Open the Download as pane to save the currently viewed spreadsheet to the computer hard disk drive in one of the supported formats: XLSX, ODS, CSV, HTML.
Full screen F11 Switch to the full screen view to fit Spreadsheet Editor into your screen.
Help menu F1 Open Spreadsheet Editor Help menu.
Navigation
Jump to the beginning of the row Home Outline the A column of the current row.
Jump to the beginning of the spreadsheet Ctrl+Home Outline the A1 cell.
Jump to the end of the row End Outline the last cell of the current row.
Jump to the end of the spreadsheet Ctrl+End Outline the last cell of the spreadsheet situated at the bottommost row with data of the rightmost column with data. If the cursor is at the formula line, it will be placed to the end of the text.
Move to the previous sheet Alt+PgUp Move to the previous sheet in your spreadsheet.
Move to the next sheet Alt+PgDn Move to the next sheet in your spreadsheet.
Move up one row Up Arrow Outline the cell above the current one in the same column.
Move down one row Down Arrow Outline the cell below the current one in the same column.
Move left one column Left Arrow, or
Tab
Outline the previous cell of the current row.
Move right one column Right Arrow, or
Tab+Shift
Outline the next cell of the current row.
Data Selection
Select all Ctrl+A, or
Ctrl+Shift+Spacebar
Select the entire worksheet.
Select column Ctrl+Spacebar Select an entire column in a worksheet.
Select row Shift+Spacebar Select an entire row in a worksheet.
Select fragment Shift+Arrow Select the cell by cell.
Select from cursor to beginning of row Shift+Home Select a fragment from the cursor to the beginning of the current row.
Select from cursor to end of row Shift+End Select a fragment from the cursor to the end of the current row.
Extend the selection Ctrl+Shift+Home Select a fragment from the current selected cells to the beginning of the worksheet.
Undo and Redo
Undo Ctrl+Z Reverse the latest performed action.
Redo Ctrl+Y Repeat the latest undone action.
Cut, Copy, and Paste
Cut Ctrl+X Cut the the selected data and send them to the computer clipboard memory. The cut data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program.
Copy Ctrl+C Send the selected data to the computer clipboard memory. The copied data can be later inserted to another place in the same worksheet, into another spreadsheet, or into some other program.
Paste Ctrl+V Insert the previously copied/cut data from the computer clipboard memory to the current cursor position. The data can be previously copied from the same worksheet, from another spreadsheet, or from some other program.
Data Formatting
Bold Ctrl+B Make the font of the selected text fragment bold giving it more weight or remove bold formatting.
Italic Ctrl+I Make the font of the selected text fragment italicized giving it some right side tilt or remove italic formatting.
Underline Ctrl+U Make the selected text fragment underlined with the line going under the letters or remove underlining.
Strikeout Ctrl+5 Make the selected text fragment struck out with the line going through the letters or remove strikeout formatting.
Add Hyperlink Ctrl+K Insert a hyperlink to an external website or another worksheet.
Data Filtering
Enable/Remove Filter Ctrl+Shift+L Enable a filter for a selected cell range or remove the filter.
Format as table template Ctrl+L Apply a table template to a selected cell range.
Data Entry
Complete cell entry and move down Enter Complete a cell entry in the selected cell or the formula bar, and move to the cell below.
Complete cell entry and move up Shift+Enter Complete a cell entry in the selected cell, and move to the cell above.
Start new line Alt+Enter Start a new line in the same cell.
Cancel Esc Cancel an entry in the selected cell or the formula bar.
Delete to the left BACKSPACE Delete one character to the left in the formula bar or in the selected cell when the cell editing mode is activated.
Delete to the right Delete Delete one character to the right in the formula bar or in the selected cell when the cell editing mode is activated.
Clear cell content Delete Remove the content (data and formulas) from selected cells without affecting cell format or comments.
Functions
SUM function Alt+'=' Insert the SUM function into the selected cell.

*available for paid versions only

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action