| 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 Spreadsheet Editor help or 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 characters you need. |
| 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 |
Alt+Q |
^ Ctrl+⌥ Option+Q |
Open the Chat panel and send a message. |
| Save spreadsheet |
Ctrl+S |
^ Ctrl+S,
⌘ Cmd+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 |
^ 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 |
F11 |
|
Switch to the full screen view to fit Spreadsheet Editor into your screen. |
| Help menu |
F1 |
F1 |
Open Spreadsheet Editor Help menu. |
| Open existing file (Desktop Editors) |
Ctrl+O |
|
On the Open local file tab in Desktop Editors, opens the standard dialog box that allows to select an existing file. |
| Close file (Desktop Editors) |
Ctrl+W,
Ctrl+F4 |
^ Ctrl+W,
⌘ Cmd+W |
Close the current spreadsheet window in Desktop Editors. |
| Element contextual menu |
⇧ Shift+F10 |
⇧ Shift+F10 |
Open the selected element contextual menu. |
| 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 current data region |
Ctrl+← → ↑ ↓ |
⌘ Cmd+← → ↑ ↓ |
Outline a cell at the edge of the current data region in a worksheet. |
| 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 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 |
⌥ 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. |
| Zoom In |
Ctrl++ |
^ Ctrl+=,
⌘ Cmd+= |
Zoom in the currently edited spreadsheet. |
| Zoom Out |
Ctrl+- |
^ Ctrl+-,
⌘ Cmd+- |
Zoom out the currently edited spreadsheet. |
| 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 the 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 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 |
⇧ 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 bold giving it more weight or remove bold formatting. |
| Italic |
Ctrl+I |
^ Ctrl+I,
⌘ Cmd+I |
Make the font of the selected text fragment italicized giving it some right side tilt or remove italic formatting. |
| Underline |
Ctrl+U |
^ Ctrl+U,
⌘ Cmd+U |
Make the selected text fragment underlined with the line going under the letters or remove underlining. |
| Strikeout |
Ctrl+5 |
^ Ctrl+5,
⌘ Cmd+5 |
Make the selected text fragment struck out with the 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. |
| 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 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 . |
| Functions |
| 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+~ |
Applies the General number format. |
| Apply the Currency format |
Ctrl+⇧ Shift+$ |
^ Ctrl+⇧ Shift+$ |
Applies the Currency format with two decimal places (negative numbers in parentheses). |
| Apply the Percentage format |
Ctrl+⇧ Shift+% |
^ Ctrl+⇧ Shift+% |
Applies the Percentage format with no decimal places. |
| Apply the Exponential format |
Ctrl+⇧ Shift+^ |
^ Ctrl+⇧ Shift+^ |
Applies the Exponential number format with two decimal places. |
| Apply the Date format |
Ctrl+⇧ Shift+# |
^ Ctrl+⇧ Shift+# |
Applies the Date format with the day, month, and year. |
| Apply the Time format |
Ctrl+⇧ Shift+@ |
^ Ctrl+⇧ Shift+@ |
Applies the Time format with the hour and minute, and AM or PM. |
| Apply the Number format |
Ctrl+⇧ Shift+! |
^ Ctrl+⇧ Shift+! |
Applies 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. |