3. Entering/editing data |
| Ctrl+a | Select the all / entire worksheet |
| Ctrl+b | Bold the contents of the selected cell |
| Ctrl+c | Copy the contents of the selected cell |
| Ctrl+f | Find words or phrases within the spreadsheet |
| Ctrl+i | Italicize the contents of the selected cell |
| Ctrl+p | Print |
| Ctrl+r | Copy the content of the selected cell right (used in combo with Shift + arrow) |
| Ctrl+s | Save |
| Ctrl+u | Underline the contents of the selected cell |
| Ctrl+v | Paste the contents of the selected cell |
| Ctrl+x | Cut the contents of the selected cell |
| Ctrl+y | Redo the last action |
| Ctrl+z | Undo the last action. |
| Enter | Complete a cell entry and select the cell below |
| Shift+Enter | Complete a cell entry and select the previous cell above |
| Alt+Enter | Start a new line in the same cell |
| Ctrl+Enter | Insert line break in a cell |
| Tab | Complete a cell entry and select the next cell to the right |
| Shift+Tab | Complete a cell entry and select the previous cell to the left |
| F2 | Edit the active cell and position the insertion point at the end of the cell contents |
| Shift+F2 | Edit comment |
| Esc | Cancel cell entry |
| Backspace | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents |
| Delete | Delete the character to the right of the insertion point, or delete the selection |
| Ctrl+Space | Select the entire column |
| Shift+Space | Select the entire row |
| Shift+Arrow Keys | Manual select |
| Ctrl+Shift+s | Make a copy of the document |
| Alt+Shift+5 | Strikethrough formatting for the contents of the cell |
| Alt+Shift+& | Apply border outline to selected cells |
| Alt+Shift+_ | Remove border outline from selected cells |
| Alt+Shift+t | Apply or remove top border from the selected cells |
| Alt+Shift+b | Apply or remove bottom border from the selected cells |
| Alt+Shift+r | Apply or remove right border from the selected cells |
| Alt+Shift+l | Apply or remove left border from the selected cells |
Comments