| 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. |