Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud

Keyboard Shortcuts

Keyboard Shortcuts for Key Tips

Use keyboard shortcuts for a faster and easier access to the features of the Spreadsheet Editor without using a mouse.

  1. Press Alt key to turn on all key tips for the editor header, the top toolbar, the right and left sidebars and the status bar.
  2. Press the letter that corresponds to the item you wish to use. The additional key tips may appear depending on the key you press. The first key tips hide when additional key tips appear.

    For example, to access the Insert tab, press Alt to see all primary key tips.

    Primary Key Tips

    Press letter I to access the Insert tab and you will see all the available shortcuts for this tab.

    Secondary Key Tips

    Then press the letter that corresponds to the item you wish to configure.

  3. Press Alt to hide all key tips, or press Escape to go back to the previous group of key tips.

Find the most common keyboard shortcuts in the list below:

  • Windows/Linux
  • Mac OS
Working with Spreadsheet
Open 'File' panel Alt+F ^ Ctrl+⌥ Option+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 the help menu of the Spreadsheet Editor or its advanced settings.
Open 'Find and Replace' dialog box Ctrl+F ^ Ctrl+F,
⌘ Cmd+F
Open the Find and Replace dialog box to start searching for a cell containing the required characters.
Open 'Find and Replace' dialog box with replacement field Ctrl+H ^ 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 ^ Ctrl+⇧ Shift+H,
⌘ Cmd+⇧ Shift+H
Open the Comments panel to add your own comment or reply to other users' comments.
Open comment field Alt+H ⌘ Cmd+⌥ Option+A Open a data entry field where you can add the text of your comment.
Open 'Chat' panel (Online Editors) Alt+Q ^ Ctrl+⌥ Option+Q Open the Chat panel in the Online Editors and send a message.
Save spreadsheet Ctrl+S ^ Ctrl+S,
⌘ Cmd+S
Save all the changes to the spreadsheet currently edited with the Spreadsheet Editor. The active file will be saved with its current file name, location, and file format.
Print spreadsheet Ctrl+P ^ Ctrl+P,
⌘ Cmd+P
Print your spreadsheet with one of the available printers or save it to a file.
Download as... Ctrl+⇧ Shift+S ^ Ctrl+⇧ Shift+S,
⌘ Cmd+⇧ 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, XLTX, PDF/A, OTS.
Full screen (Online Editors) F11 Switch to the full screen view in the Online Editors to fit the Spreadsheet Editor on the screen.
Help menu F1 F1 Open the Help menu of the Spreadsheet Editor .
Open existing file (Desktop Editors) Ctrl+O Open the standard dialog box on the Open local file tab in the Desktop Editors that allows you to select an existing file.
Close file (Desktop Editors) Tab/Shift+Tab ↹ Tab/⇧ Shift+↹ Tab Close the current spreadsheet window in the Desktop Editors.
Element contextual menu ⇧ Shift+F10 ⇧ Shift+F10 Open the contextual menu of the selected element.
Reset the ‘Zoom’ parameter Ctrl+0 ^ Ctrl+0 or ⌘ Cmd+0 Reset the ‘Zoom’ parameter of the current spreadsheet to a default 100%.
Duplicate a worksheet Press and hold down Ctrl+ drag the sheet tab Press and hold down ⌥ Option+ drag the sheet tab Copy an entire worksheet in a workbook and move it to the tab location you need.
Navigation
Move one cell up, down, left, or right Outline a cell above/below the currently selected one or to the left/to the right of it.
Jump to the edge of the visible data region or the next cell with data Ctrl+ ⌘ Cmd+ Outline a cell at the edge of the visible data region or the next cell with data in a worksheet. If the region does not contain data, the last cell of the visible area will be selected. If the region contains data, the next cell with data will be selected.
Jump to the beginning of the row Home Home Outline a cell in the column A of the current row.
Jump to the beginning of the spreadsheet Ctrl+Home ^ Ctrl+Home Outline the cell A1.
Jump to the end of the row End,
Ctrl+
End,
⌘ Cmd+
Outline the last cell of the current row.
Jump to the end of the spreadsheet Ctrl+End ^ Ctrl+End Outline the lower right used cell in the worksheet situated in 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 ⌥ Option+Page Up Move to the previous sheet in your spreadsheet.
Move to the next sheet Alt+Page Down ⌥ Option+Page Down Move to the next sheet in your spreadsheet.
Move up one row ,
⇧ Shift+↵ Enter
⇧ Shift+↵ Return Outline the cell above the current one in the same column.
Move down one row ,
↵ Enter
↵ Return Outline the cell below the current one in the same column.
Move left one column ,
⇧ Shift+↹ Tab
,
⇧ Shift+↹ Tab
Outline the previous cell of the current row.
Move right one column ,
↹ Tab
,
↹ Tab
Outline the next cell of the current row.
Move down one screen Page Down Page Down Move one screen down in the worksheet.
Move up one screen Page Up Page Up Move one screen up in the worksheet.
Move vertical scrollbar Up/Down Mouse scroll Up/Down Mouse scroll Up/Down Move vertical scrollbar up/down.
Move horizontal scrollbar Left/Right ⇧ Shift+Mouse scroll Up/Down ⇧ Shift+Mouse scroll Up/Down Move horizontal scrollbar left/right. To move the scrollbar to the right, scroll the mouse wheel down. To move the scrollbar to the left, scroll the mouse wheel up.
Zoom In Ctrl++ ^ Ctrl+=,
⌘ Cmd+=
Zoom in the currently edited spreadsheet.
Zoom Out Ctrl+- ^ Ctrl+-,
⌘ Cmd+-
Zoom out the currently edited spreadsheet.
Navigate between controls in modal dialogues ↹ Tab/⇧ Shift+↹ Tab ↹ Tab/⇧ Shift+↹ Tab Navigate between controls to give focus to the next or previous control in modal dialogues.
Data Selection
Select all Ctrl+A,
Ctrl+⇧ Shift+␣ Spacebar
⌘ Cmd+A Select the entire worksheet.
Select column Ctrl+␣ Spacebar ^ Ctrl+␣ Spacebar Select an entire column in a worksheet.
Select row ⇧ Shift+␣ Spacebar ⇧ Shift+␣ Spacebar Select an entire row in a worksheet.
Select fragment ⇧ Shift+ ⇧ Shift+ Select a fragment cell by cell.
Select from cursor to beginning of row ⇧ Shift+Home ⇧ Shift+Home Select a fragment from the cursor to the beginning of the current row.
Select from cursor to end of row ⇧ Shift+End ⇧ 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 ^ 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 ^ Ctrl+⇧ Shift+End Select a fragment from the current selected cells to the last used cell in the worksheet (in 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 ⇧ Shift+↹ Tab Select one cell to the left in a table.
Select one cell to the right ↹ Tab ↹ Tab Select one cell to the right in a table.
Extend the selection to the nearest nonblank cell to the right ⇧ Shift+End,
Ctrl+⇧ Shift+
⇧ Shift+End Extend the selection to the nearest nonblank cell in the same row to the right of the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.
Extend the selection to the nearest nonblank cell to the left ⇧ Shift+Home,
Ctrl+⇧ Shift+
⇧ Shift+Home Extend the selection to the nearest nonblank cell in the same row to the left of the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.
Extend the selection to the nearest nonblank cell up/down the column Ctrl+⇧ Shift+ Extend the selection to the nearest nonblank cell in the same column up/down from the active cell. If the next cell is blank, the selection will be extended to the next nonblank cell.
Extend the selection down one screen ⇧ Shift+Page Down ⇧ Shift+Page Down Extend the selection to include all the cells one screen down from the active cell.
Extend the selection up one screen ⇧ Shift+Page Up ⇧ Shift+Page Up Extend the selection to include all the cells one screen up from the active cell.
Undo and Redo
Undo Ctrl+Z ⌘ Cmd+Z Reverse the latest performed action.
Redo Ctrl+Y ⌘ Cmd+Y Repeat the latest undone action.
Cut, Copy, and Paste
Cut Ctrl+X,
⇧ Shift+Delete
⌘ Cmd+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,
Ctrl+Insert
⌘ Cmd+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,
⇧ Shift+Insert
⌘ Cmd+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 ^ Ctrl+B,
⌘ Cmd+B
Make the font of the selected text fragment darker and heavier than normal or remove the bold formatting.
Italic Ctrl+I ^ Ctrl+I,
⌘ Cmd+I
Make the font of the selected text fragment italicized and slightly slanted or remove italic formatting.
Underline Ctrl+U ^ Ctrl+U,
⌘ Cmd+U
Make the selected text fragment underlined with a line going under the letters or remove underlining.
Strikeout Ctrl+5 ^ Ctrl+5,
⌘ Cmd+5
Make the selected text fragment struck out with a line going through the letters or remove strikeout formatting.
Add Hyperlink Ctrl+K ⌘ Cmd+K Insert a hyperlink to an external website or another worksheet.
Edit active cell F2 F2 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 ^ Ctrl+⇧ Shift+L,
⌘ Cmd+⇧ Shift+L
Enable a filter for a selected cell range or remove the filter.
Format as table template Ctrl+L ^ Ctrl+L,
⌘ Cmd+L
Apply a table template to a selected cell range.
Data Entry
Complete cell entry and move down ↵ Enter ↵ Return 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 ⇧ Shift+↵ Return Complete a cell entry in the selected cell, and move to the cell above.
Complete cell entry and move to the next cell in a row ↹ Tab ↹ Tab Complete a cell entry in the selected cell or the formula bar, and move to the cell to the right.
Start new line Alt+↵ Enter Start a new line in the same cell.
Cancel Esc Esc Cancel an entry in the selected cell or the formula bar.
Delete to the left ← Backspace ← 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,
Fn+← Backspace
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,
← Backspace
Delete,
← Backspace
Remove the content (data and formulas) from selected cells without affecting the cell format or comments.
Complete a cell entry and move to the right ↹ Tab ↹ 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 ⇧ Shift+↹ Tab Complete a cell entry in the selected cell or the formula bar and move to the cell on the left .
Insert cells Ctrl+⇧ Shift+= Ctrl+⇧ Shift+=,
⌘ Cmd+⇧ Shift+=
Open the dialog box for inserting new cells within current spreadsheet with an added parameter of a shift to the right, a shift down, inserting an entire row or an entire column.
Delete cells Ctrl+⇧ Shift+- Ctrl+⇧ Shift+-,
⌘ Cmd+⇧ Shift+-
Open the dialog box for deleting cells within current spreadsheet with an added parameter of a shift to the left, a shift up, deleting an entire row or an entire column.
Insert the current date Ctrl+; Ctrl+;,
⌘ Cmd+;
Insert the today date within an active cell.
Insert the current time Ctrl+⇧ Shift+; Ctrl+⇧ Shift+;,
⌘ Cmd+⇧ Shift+;
Insert the current time within an active cell.
Insert the current date and time Ctrl+; then ␣ Spacebar then Ctrl+⇧ Shift+; Ctrl+; then ␣ Spacebar then Ctrl+⇧ Shift+;,
⌘ Cmd+; then ␣ Spacebar then ⌘ Cmd+⇧ Shift+;
Insert the current date and time within an active cell.
Pivot tables
Update pivot table Alt+F5 ⌥ Option+F5 Update the previously selected pivot table.
Functions
Insert function ⇧ Shift+F3 ⇧ Shift+F3 Open the dialog box for inserting a new function by choosing from the provided list.
SUM function Alt+= ⌥ Option+Ctrl+= Insert the SUM function into the selected cell.
Open drop-down list Alt+ Open a selected drop-down list.
Open contextual menu ≣ Menu Open a contextual menu for the selected cell or cell range.
Recalculate functions F9 F9 Recalculate the entire workbook.
Recalculate functions ⇧ Shift+F9 ⇧ Shift+F9 Recalculate the current worksheet.
Data Formats
Open the 'Number Format' dialog box Ctrl+1 ^ Ctrl+1,
⌘ Cmd+1
Open the Number Format dialog box.
Apply the General format Ctrl+⇧ Shift+~ ^ Ctrl+⇧ Shift+~ Apply the General number format.
Apply the Currency format Ctrl+⇧ Shift+$ ^ Ctrl+⇧ Shift+$ Apply the Currency format with two decimal places (negative numbers in parentheses).
Apply the Percentage format Ctrl+⇧ Shift+% ^ Ctrl+⇧ Shift+% Apply the Percentage format with no decimal places.
Apply the Exponential format Ctrl+⇧ Shift+^ ^ Ctrl+⇧ Shift+^ Apply the Exponential number format with two decimal places.
Apply the Date format Ctrl+⇧ Shift+# ^ Ctrl+⇧ Shift+# Apply the Date format with the day, month, and year.
Apply the Time format Ctrl+⇧ Shift+@ ^ Ctrl+⇧ Shift+@ Apply the Time format with the hour and minute, and AM or PM.
Apply the Number format Ctrl+⇧ Shift+! ^ Ctrl+⇧ Shift+! Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Modifying Objects
Constrain movement ⇧ Shift + drag ⇧ Shift + drag Constrain the movement of the selected object horizontally or vertically.
Set 15-degree rotation ⇧ Shift + drag (when rotating) ⇧ Shift + drag (when rotating) Constrain the rotation angle to 15-degree increments.
Maintain proportions ⇧ Shift + drag (when resizing) ⇧ Shift + drag (when resizing) Maintain the proportions of the selected object when resizing.
Draw straight line or arrow ⇧ Shift + drag (when drawing lines/arrows) ⇧ Shift + drag (when drawing lines/arrows) Draw a straight vertical/horizontal/45-degree line or arrow.
Movement by one-pixel increments Ctrl+ 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