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 'Find and Replace' dialog box Ctrl+F Open the Find and Replace dialog box to start searching for a cell containing the characters you need.
Open 'Find and Replace' dialog box with replacement field Ctrl+H Open the Find and Replace dialog box with the replacement field to replace one or more occurrences of the found characters.
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. The active file will be saved with its current file name, location, and file format.
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... panel to save the currently edited spreadsheet to the computer hard disk drive in one of the supported formats: XLSX, PDF, ODS, CSV.
Full screen F11 Switch to the full screen view to fit Spreadsheet Editor into your screen.
Help menu F1 Open Spreadsheet Editor Help menu.
Open existing file Ctrl+O On the Open local file tab in desktop editors, opens the standard dialog box that allows to select an existing file.
Element contextual menu Shift+F10 Open the selected element contextual menu.
Close file Ctrl+W Close the selected workbook window.
Close the window (tab) Ctrl+F4 Close the tab in a browser.
Navigation
Move one cell up, down, left, or right Arrow keys Outline a cell above/below the currently selected one or to the left/to the right of it.
Jump to the edge of the current data region Ctrl+Arrow keys Outline a cell at the edge of the current data region in a worksheet.
Jump to the beginning of the row Home Outline a cell in the column A of the current row.
Jump to the beginning of the spreadsheet Ctrl+Home Outline the cell A1.
Jump to the end of the row End, or Ctrl+Right arrow Outline the last cell of the current row.
Jump to the end of the spreadsheet Ctrl+End Outline the lower right used cell on the worksheet situated at the bottommost row with data of the rightmost column with data. If the cursor is in the formula bar, it will be placed to the end of the text.
Move to the previous sheet Alt+Page Up Move to the previous sheet in your spreadsheet.
Move to the next sheet Alt+Page Down Move to the next sheet in your spreadsheet.
Move up one row Up arrow, or Shift+Enter Outline the cell above the current one in the same column.
Move down one row Down arrow, or Enter Outline the cell below the current one in the same column.
Move left one column Left arrow, or
Shift+Tab
Outline the previous cell of the current row.
Move right one column Right arrow, or
Tab
Outline the next cell of the current row.
Move down one screen Page Down Move one screen down in the worksheet.
Move up one screen Page Up Move one screen up in the worksheet.
Zoom In Ctrl+Plus sign (+) Zoom in the currently edited spreadsheet.
Zoom Out Ctrl+Minus sign (-) Zoom out the currently edited spreadsheet.
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 to beginning of worksheet Ctrl+Shift+Home Select a fragment from the current selected cells to the beginning of the worksheet.
Extend the selection to the last used cell Ctrl+Shift+End Select a fragment from the current selected cells to the last used cell on the worksheet (at the bottommost row with data of the rightmost column with data). If the cursor is in the formula bar, this will select all text in the formula bar from the cursor position to the end without affecting the height of the formula bar.
Select one cell to the left Shift+Tab Select one cell to the left in a table.
Select one cell to the right Tab Select one cell to the right in a table.
Extend the selection to the last nonblank cell Ctrl+Shift+Arrow key Extend the selection to the last nonblank cell in the same column or row as the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.
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, Shift+Delete 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, Ctrl+Insert 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, Shift+Insert 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.
Edit active cell F2
CONTROL+U (for Mac)
Edit the active cell and position the insertion point at the end of the cell contents. If editing in a cell is turned off, the insertion point will be moved into the Formula Bar.
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. Also removes the content of the active cell.
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. Also removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
Clear cell content Delete Remove the content (data and formulas) from selected cells without affecting cell format or comments.
Complete a cell entry and move to the right Tab Complete a cell entry in the selected cell or the formula bar and move to the cell on the right.
Complete a cell entry and move to the left Shift+Tab Complete a cell entry in the selected cell or the formula bar and move to the cell on the left .
Functions
SUM function Alt+Equal sign (=) Insert the SUM function into the selected cell.
Open drop-down list Alt+Down arrow Open a selected drop-down list.
Open contextual menu Context menu key Open a contextual menu for the selected cell or cell range.
Data Formats
Open the 'Number Format' dialog box Ctrl+1 Open the Number Format dialog box.
Apply the General format Ctrl+Shift+~ Applies the General number format.
Apply the Currency format Ctrl+Shift+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
Apply the Percentage format Ctrl+Shift+% Applies the Percentage format with no decimal places.
Apply the Exponential format Ctrl+Shift+^ Applies the Exponential number format with two decimal places.
Apply the Date format Ctrl+Shift+# Applies the Date format with the day, month, and year.
Apply the Time format Ctrl+Shift+@ Applies the Time format with the hour and minute, and AM or PM.
Apply the Number format Ctrl+Shift+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Modifying Objects
Constrain movement Shift+drag Constrain the movement of the selected object horizontally or vertically.
Set 15-degree rotation Shift+drag (when rotating) Constrain the rotation angle to 15-degree increments.
Maintain proportions Shift+drag (when resizing) Maintain the proportions of the selected object when resizing.
Draw straight line or arrow Shift+drag (when drawing lines/arrows) Draw a straight vertical/horizontal/45-degree line or arrow.
Movement by one-pixel increments Ctrl+Arrow keys Hold down the Ctrl key and use the keybord arrows to move the selected object by one pixel at a time.
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