Find the most common keyboard shortcuts in the list below.
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' dialog window |
Ctrl+F |
^ Ctrl+F, ⌘ Cmd+F |
Open the Find dialog window to start searching for a cell containing the required characters. |
Open 'Find and Replace' menu (panel) with replacement field |
Ctrl+H |
^ Ctrl+H |
Open the Find and Replace menu (panel) 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, XLTX, PDF, PDF/A, ODS, OTS, CSV, PNG, JPG. |
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 |
Fn+F1 |
Open the Help menu of the Spreadsheet Editor. |
Open existing file |
Ctrl+O |
⌘ Cmd+O |
Open the standard dialog box that allows selecting an existing file. If you select the file in this dialog box and click Open, the file will be opened in a new tab or window of Desktop Editors. |
Switch to the next tab |
Ctrl+↹ Tab |
^ Ctrl+↹ Tab |
Switch to the next file tab in Desktop Editors or browser tab in Online Editors. |
Switch to the previous tab |
Ctrl+Shift+↹ Tab |
^ Ctrl+⇧ Shift+↹ Tab |
Switch to the previous file tab in Desktop Editors or browser tab in Online Editors. |
Close file |
Ctrl+W, Ctrl+F4 |
⌘ Cmd+W |
Close the current spreadsheet window. |
Element contextual menu |
⇧ Shift+F10 |
⇧ Shift+Fn+F10 |
Open the contextual menu of the selected element. |
Close menu or modal window, reset modes, etc. |
Esc |
Esc |
Close a menu or modal window. Suspend copying formats. Reset adding shapes mode. Clear clipboard when cutting/copying cells. Hide the Paste Special button. |
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. |
Move active cell down |
↵ Enter |
↵ Return |
Move to the cell below. |
Move active cell up |
⇧ Shift+↵ Enter |
⇧ Shift+↵ Return |
Move to the cell above. |
Move active cell to the right |
↹ Tab |
↹ Tab |
Move to the cell on the right. |
Move active cell to the left |
⇧ Shift+↹ Tab |
⇧ Shift+↹ Tab |
Move to the cell on the left . |
Jump to the edge of the visible data region or the next cell with data |
Ctrl+← → ↑ ↓ |
⌘ Cmd+← → ↑ ↓
Home End Page Up Page Down |
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 |
Fn+←
Home |
Outline a cell in the column A of the current row. |
Jump to the beginning of the spreadsheet |
Ctrl+Home |
^ Ctrl+Fn+←, ⌘ Cmd+Fn+←
^ Ctrl+Home, ⌘ Cmd+Home |
Outline the cell A1. |
Jump to the end of the row |
End, Ctrl+→ |
Fn+→, ⌘ Cmd+→
End |
Outline the last cell of the current row. |
Jump to the end of the spreadsheet |
Ctrl+End |
^ Ctrl+Fn+→, ⌘ Cmd+Fn+→
^ Ctrl+End, ⌘ Cmd+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+Fn+↑
⌥ Option+Page Up |
Move to the previous sheet in your spreadsheet. |
Move to the next sheet |
Alt+Page Down |
⌥ Option+Fn+↓
⌥ 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 |
Fn+↓
Page Down |
Move one screen down in the worksheet. |
Move up one screen |
Page Up |
Fn+↑
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 the entire worksheet |
Ctrl+A, Ctrl+⇧ Shift+␣ Spacebar |
⌘ Cmd+A, ^ Ctrl+A |
Select the entire worksheet (when the focus is on a cell). |
Select column |
Ctrl+␣ Spacebar |
^ Ctrl+Fn+␣ Spacebar, ⌘ Cmd+Fn+␣ Spacebar |
Select an entire column in a worksheet. |
Select row |
⇧ Shift+␣ Spacebar |
⇧ Shift+␣ Spacebar |
Select an entire row in a worksheet. |
Select one cell to the right |
⇧ Shift+→ |
⇧ Shift+→ |
Select one cell to the right. |
Select one cell to the left |
⇧ Shift+← |
⇧ Shift+← |
Select one cell to the left. |
Select one cell up |
⇧ Shift+↑ |
⇧ Shift+↑ |
Select one cell up. |
Select one cell down |
⇧ Shift+↓ |
⇧ Shift+↓ |
Select one cell down. |
Select from cursor to beginning of row |
⇧ Shift+Home |
⇧ Shift+Fn+←
⇧ 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+Fn+→
⇧ Shift+End |
Select a fragment from the cursor to the end of the current row. |
Select to the next nonblank cell to the right |
Ctrl+⇧ Shift+→ |
^ Ctrl+⇧ Shift+→, ⌘ Cmd+⇧ Shift+→ |
Select cells to the next nonblank cell to the right of the active cell or to the edge of the visible area. |
Select to the next nonblank cell to the left |
Ctrl+⇧ Shift+← |
^ Ctrl+⇧ Shift+←, ⌘ Cmd+⇧ Shift+← |
Select cells to the next nonblank cell to the left of the active cell or to the edge of the visible area. |
Select to the next nonblank cell up |
Ctrl+⇧ Shift+↑ |
^ Ctrl+⇧ Shift+↑, ⌘ Cmd+⇧ Shift+↑ |
Select cells to the next nonblank cell up from the active cell or to the edge of the visible area. |
Select to the next nonblank cell down |
Ctrl+⇧ Shift+↓ |
^ Ctrl+⇧ Shift+↓, ⌘ Cmd+⇧ Shift+↓ |
Select cells to the next nonblank cell down from the active cell or to the edge of the visible area. |
Extend the selection to beginning of worksheet |
Ctrl+⇧ Shift+Home |
^ Ctrl+⇧ Shift+Fn+←, ⌘ Cmd+⇧ Shift+Fn+←
^ Ctrl+⇧ Shift+Home, ⌘ Cmd+⇧ 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+Fn+→, ⌘ Cmd+⇧ Shift+Fn+→
^ Ctrl+⇧ Shift+End, ⌘ Cmd+⇧ 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. |
Extend the selection to the nearest nonblank cell to the right |
⇧ Shift+End, Ctrl+⇧ Shift+→ |
⇧ Shift+Fn+→
⇧ 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 nonblank cell to the left |
Ctrl+⇧ Shift+← |
|
Extend the selection to the nonblank cell to the left. |
Extend the selection to the first column |
⇧ Shift+Home |
⇧ Shift+Fn+←
⇧ Shift+Home |
Extend the selection to the first column (A). |
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+Fn+↓
⇧ Shift+Page Down |
Extend the selection to include all the cells one screen down from the active cell. All cells in the columns of the previously selected range will be selected. |
Extend the selection up one screen |
⇧ Shift+Page Up |
⇧ Shift+Fn+↑
⇧ Shift+Page Up |
Extend the selection to include all the cells one screen up from the active cell. All cells in the columns of the previously selected range will be selected. |
Undo and Redo |
Undo |
Ctrl+Z |
⌘ Cmd+Z, ^ Ctrl+Z |
Reverse the latest performed action. |
Redo |
Ctrl+Y |
⌘ Cmd+Y, ^ Ctrl+Y |
Repeat the latest undone action. |
Cut, Copy, and Paste |
Cut |
Ctrl+X, ⇧ Shift+Delete |
⌘ Cmd+X |
Cut the the selected data/graphics 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/graphics 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/graphics 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. |
Paste Special options 1 |
Paste only formula |
Ctrl then F |
^ Ctrl then F |
Paste formulas without pasting the data formatting. |
Paste formula + number format |
Ctrl then O |
^ Ctrl then O |
Paste formulas with the formatting applied to numbers. |
Paste formula + all formatting |
Ctrl then K |
^ Ctrl then K |
Paste formulas with all the data formatting. |
Paste formula without borders |
Ctrl then B |
^ Ctrl then B |
Paste formulas with all the data formatting except the cell borders. |
Paste formula + column width |
Ctrl then W |
^ Ctrl then W |
Paste formulas with all the data formatting and set the source column`s width for the cell range. |
Transpose |
Ctrl then T |
^ Ctrl then T |
Paste data switching them from columns to rows, or vice versa. This option is available for regular data ranges, but not for formatted tables. |
Paste only value |
Ctrl then V |
^ Ctrl then V |
Paste the formula results without pasting the data formatting. |
Paste value + number format |
Ctrl then A |
^ Ctrl then A |
Paste the formula results with the formatting applied to numbers. |
Paste value + all formatting |
Ctrl then E |
^ Ctrl then E |
Paste the formula results with all the data formatting. |
Paste only formatting |
Ctrl then R |
^ Ctrl then R |
Paste the cell formatting only without pasting the cell contents. |
Paste link |
Ctrl then N |
^ Ctrl then N |
Paste the external link to a cell or range of cells in another spreadsheet within the current portal (in the online editor) or in a local file (in the desktop editor). |
Working with Hyperlinks |
Insert hyperlink |
Ctrl+K |
⌘ Cmd+K, ^ Ctrl+K |
Insert a hyperlink which can be used to go to a web address. |
Visit hyperlink |
Enter |
Return |
Visit a hyperlink (with the cursor in the hyperlink). |
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 |
⌘ 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. |
Edit active cell |
F2 |
Fn+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. |
Open filter window |
Alt+↓ |
⌥ Option+↓ |
In the header of a column with a filter, open the filter window. |
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 right |
↹ Tab |
↹ Tab |
Complete a cell entry in the selected cell or the formula bar and move to the cell on the right. |
Complete 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 . |
Complete cell entry and stay in it |
Ctrl+⇧ Shift+↵ Enter, Ctrl+↵ Enter |
^ Ctrl+⇧ Shift+↵ Return, ^ Ctrl+↵ Return |
Complete a cell entry in the selected cell or the formula bar and stay in it. |
Fill the selected cell range with the current entry |
Ctrl+↵ Enter |
^ Ctrl+↵ Return |
Fill the selected cell range with the current entry. Select a cell range, type data to the active cell and press the specified keys to fill all the selected cells with entered data. |
Start new line |
Alt+↵ Enter |
⌥ Option+↵ Return |
Start a new line in the same cell. |
Add new placeholder to equation argument |
Enter |
Return, ⇧ Shift+Return |
Add a new placeholder to the equation argument. |
Cancel |
Esc |
Esc |
Cancel an entry in the selected cell or the formula bar. |
Delete to the left |
← Backspace |
Delete |
Delete one character to the left in the formula bar or in the selected cell when the cell editing mode is activated. Remove the selection. Also removes the content of the active cell. It is also applicable to text in graphical objects. |
Delete to the right |
Delete |
Fn+Delete |
Delete one character to the right in the formula bar or in the selected cell when the cell editing mode is activated. Remove the selection. Also removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. It is also applicable to text in graphical objects. |
Clear active cell content |
Delete, ← Backspace |
Delete |
Remove the content (data and formulas) from the active cell without affecting the cell format or comments. |
Clear content of all selected cells |
Delete |
Fn+Delete |
Remove the content (data and formulas) from all selected cells without affecting the cell format or comments. |
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. |
Insert separator |
Numpad . |
|
Insert separator within an active cell. |
Auto Fill (Open drop-down list) |
Alt+↓ |
⌥ Option+↓ |
Use this shortcut in an empty cell below or above existing values in the column. A drop-down list with existing values will appear. Select one of the available text values to fill an empty cell. |
Insert an em dash |
|
⌥ Option+⇧ Shift+- |
Insert an em dash ‘—’ within the current cell. |
Insert an en dash |
|
⌥ Option+- |
Insert an en dash ‘-’ within the current cell. |
Work with keyboard supporting the ability to insert Unicode symbols |
|
⌥ Option+Q, ⌥ Option+F, ⇧ Shift+⌥ Option+7, and others |
When using the ⌥ Option+keyboard symbol shortcuts, for the keyboards supporting the ability to insert Unicode symbols, the keyboard symbols are added. The examples are listed below.
With the English ABC layout, the ⌥ Option+Q shortcut inserts the "œ" symbol, the ⌥ Option+F shortcut inserts the “ƒ” function symbol.
With the US International w/o deadkeys layout, the ⌥ Option+Q shortcut inserts the “ä” symbol.
With the Swiss-german layout, the ⇧ Shift+⌥ Option+7 shortcut inserts the "\” symbol.
|
Working with text in cells and graphical objects |
Remove word, selection to the left |
Ctrl+Backspace |
⌥ Option+Delete |
Remove a word, selection to the left of the cursor. |
Remove word, selection to the right |
Ctrl+Delete |
Fn+⌥ Option+Delete |
Remove a word, selection to the right of the cursor. |
Select all |
Ctrl+A |
⌘ Cmd+A, ^ Ctrl+A |
Select the entire shape content (when the cursor is within the shape content). Select the entire cell content (when the cursor is within the cell). |
Move one character to the left/right or one line up/down |
← → ↑ ↓ |
← → ↑ ↓ |
Move the cursor one character to the left/right or one line up/down. |
Select one character to the right |
⇧ Shift+→ |
⇧ Shift+→ |
Select one character to the right of the cursor position. |
Select one character to the left |
⇧ Shift+← |
⇧ Shift+← |
Select one character to the left of the cursor position. |
Move the cursor one word to the left |
Ctrl+← |
⌥ Option+← |
Move the cursor one word to the left. |
Move the cursor one word to the right |
Ctrl+→ |
⌥ Option+→ |
Move the cursor one word to the right. |
Select one word to the left |
Ctrl+⇧ Shift+← |
⇧ Shift+⌥ Option+← |
Select one word to the left of the cursor. |
Select one word to the right |
Ctrl+⇧ Shift+→ |
⇧ Shift+⌥ Option+→ |
Select one word to the right of the cursor. |
Jump to the beginning of the text |
Ctrl+Home |
^ Ctrl+Fn+←, ⌘ Cmd+Fn+←
^ Ctrl+Home, ⌘ Cmd+Home |
Put the cursor to the very beginning of the text in a cell or shape. |
Jump to the end of the text |
Ctrl+End |
^ Ctrl+Fn+→, ⌘ Cmd+Fn+→
^ Ctrl+End, ⌘ Cmd+End |
Put the cursor to the very end of the text in a cell or shape. |
Select from cursor to beginning of text |
Ctrl+⇧ Shift+Home |
^ Ctrl+⇧ Shift+Fn+←, ⌘ Cmd+⇧ Shift+Fn+←
^ Ctrl+⇧ Shift+Home, ⌘ Cmd+⇧ Shift+Home |
Select a text fragment from the cursor to the beginning of the text in a cell or shape. |
Select from cursor to end of text |
Ctrl+⇧ Shift+End |
^ Ctrl+⇧ Shift+Fn+→, ⌘ Cmd+⇧ Shift+Fn+→
^ Ctrl+⇧ Shift+End, ⌘ Cmd+⇧ Shift+End |
Select a text fragment from the cursor to the end of the text in a cell or shape. |
Jump to the beginning of the line |
Home |
⌘ Cmd+←
Home |
Put the cursor to the beginning of the currently edited line. |
Jump to the end of the line |
End |
⌘ Cmd+→
End |
Put the cursor to the end of the currently edited line. |
Select from cursor to beginning of line |
⇧ Shift+Home |
⇧ Shift+Fn+←
⇧ Shift+Home |
Select a text fragment from the cursor to the beginning of the current line. |
Select from cursor to end of line |
⇧ Shift+End |
⇧ Shift+Fn+→
⇧ Shift+End |
Select a text fragment from the cursor to the end of the current line. |
Select one line up |
⇧ Shift+↑ |
⇧ Shift+↑ |
Move the cursor one line up, selecting all symbols between the previous and current cursor position. |
Select one line down |
⇧ Shift+↓ |
⇧ Shift+↓ |
Move the cursor one line down, selecting all symbols between the previous and current cursor position. |
Pivot tables |
Update pivot table |
Alt+F5 |
⌥ Option+Fn+F5 |
Update the previously selected pivot table. |
Update all pivot tables |
Ctrl+Alt+F5 2 |
Ctrl+⌥ Option+Fn+F5 |
Update all pivot tables. |
Slicers |
Clear selected values |
Alt+C |
Ctrl+⌥ Option+C, ⌘ Cmd+⌥ Option+C |
Clear selected values for a slicer. |
Switch multi-select |
Alt+S |
Ctrl+⌥ Option+S, ⌘ Cmd+⌥ Option+S |
Enable/disabler multi-select for a slicer. |
Formatted tables |
Add summary row |
Ctrl+⇧ Shift+R |
Ctrl+⇧ Shift+R, ⌘ Cmd+⇧ Shift+R |
Add the Summary row for a formatted table. |
Functions |
Insert function |
⇧ Shift+F3 |
⇧ Shift+Fn+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. |
Recalculate functions |
F9 |
Fn+F9 |
Recalculate the entire workbook. |
Recalculate functions |
⇧ Shift+F9 |
⇧ Shift+Fn+F9 |
Recalculate the current worksheet. |
Display functions on sheet |
Ctrl+` |
Ctrl+` |
Display functions (not their values) on a sheet for printing them. |
Switch the type of reference |
F4 |
Fn+F4 |
Switch the type of a reference to a cell in the formula bar (absolute, relative). |
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. |
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 |
Working with shapes |
↵ Enter |
Return |
When the shape is selected, if it does not contain content, create content and move the cursor to the beginning of the line. If the content is empty, move the cursor to it, otherwise select the entire content. |
Working with charts |
↵ Enter |
|
When the chart title is selected, select the text. |
Create a copy when dragging |
Ctrl |
^ Ctrl |
Select an object and hold down the specified key when dragging the object to create the copy of the object in the location where it was moved. |
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. |
Change angle of line/arrow when drawing |
⇧ Shift + drag (when drawing lines/arrows) |
⇧ Shift + drag (when drawing lines/arrows) |
Hold down the Shift key while drawing the line/arrow and rotate the spout of the arrow/end of the line to change the angle of the line/arrow when drawing it. The line/arrow will be rotated exactly 45 degrees. |
Movement by one-pixel increments |
Ctrl+← → ↑ ↓ |
⌘ Cmd+← → ↑ ↓ |
Hold down the specified key and use the keybord arrows to move the selected object to the left, right, up, or down by one pixel at a time. |
Move shape by a big step |
← → ↑ ↓ |
← → ↑ ↓ |
Use the keybord arrows to move the selected object by a big step to the left, right, up, or down. |
Move focus to the next object |
↹ Tab |
↹ Tab |
Move focus to the next object after the currently selected one. |
Move focus to the previous object |
⇧ Shift+↹ Tab |
⇧ Shift+↹ Tab |
Move focus to the previous object before the currently selected one. |
Select all |
Ctrl+A |
⌘ Cmd+A, ^ Ctrl+A |
Select all shapes (when the focus is on a shape). |
Add tab character to the object content |
↹ Tab |
↹ Tab |
Add the tab character to the object content. |
Subscript |
Ctrl+. |
^ Ctrl+., ⌘ Cmd+. |
Make the selected text fragment smaller and place it to the lower part of the text line, e.g. as in chemical formulas. Works only with text within a graphical object. |
Superscript |
Ctrl+, |
^ Ctrl+,, ⌘ Cmd+, |
Make the selected text fragment smaller and place it to the upper part of the text line, e.g. as in fractions. Works only with text within a graphical object. |
Increase font |
Ctrl+] |
⌘ Cmd+], ^ Ctrl+] |
Increase the size of the font for the selected text fragment 1 point. Works only with text within a graphical object. |
Decrease font |
Ctrl+[ |
⌘ Cmd+[, ^ Ctrl+[ |
Decrease the size of the font for the selected text fragment 1 point. Works only with text within a graphical object. |
Align center |
Ctrl+E |
^ Ctrl+E, ⌘ Cmd+E |
Switch a paragraph between centered and left-aligned. Works only with text within a graphical object. |
Align justified |
Ctrl+J |
^ Ctrl+J, ⌘ Cmd+J |
Switch a paragraph between justified and left-aligned. Works only with text within a graphical object. |
Align right |
Ctrl+R |
^ Ctrl+R, ⌘ Cmd+R |
Switch a paragraph between right-aligned and left-aligned. Works only with text within a graphical object. |
Align left |
Ctrl+L |
^ Ctrl+L, ⌘ Cmd+L |
Align a paragraph left. Works only with text within a graphical object. |
End paragraph and start a new one |
↵ Enter |
↵ Return |
End the current paragraph and start a new one when entering text within a graphical object. |
Add line break |
⇧ Shift+↵ Enter |
⇧ Shift+↵ Return |
Add a line break without starting a new paragraph when entering text within a graphical object. |
Remove graphical object |
Delete, Ctrl+Delete, Backspace, Ctrl+Backspace |
Delete, ⌥ Option+Delete |
Remove graphical object. |
Exit from adding shapes mode, remove selection step by step |
Esc |
Esc |
Exit from adding shapes mode. Remove selection step by step (e.g., if the content of a shape within a group is selected, the cursor will be removed from the content first, then from the shape, then from the group). |
2 - This keyboard shortcut does not work on Linux.