Contents
- Overview
- Frequently used keyboard shortcuts
- Keyboard Shortcuts for the Ribbon
- Using Access Keys for Ribbon Tabs
- Working with ribbon tabs using the keyboard
- Keyboard shortcuts for cell formatting
- Keyboard shortcuts in the Paste Special dialog box in Excel 2013
- Keyboard shortcuts for actions and selections
- Keyboard shortcuts for working with data, functions, and the formula bar
- Keyboard shortcuts in Power Pivot
- Keyboard shortcuts in Office add-ins
- Function keys
- Other useful keyboard shortcuts
- Conclusion
Hotkeys are a special feature of the spreadsheet editor that allows you to get instant access to certain functions. In the article, we will deal in detail with what the spreadsheet processor has hot keys, and which procedures can be implemented with them.
Overview
Initially, note that the plus sign “+” denotes a combination of buttons. Two such “++” in a row means that “+” must be pressed together with another key on the keyboard. Service keys are buttons that must be pressed first. The service ones include: Alt, Shift, and also Ctrl.
Frequently used keyboard shortcuts
First, let’s analyze the popular combinations:
| SHIFT + TAB | Return to the previous field or the last setting in the window. |
| ARROW ↑ | Move to the top side by 1 field of the sheet. |
| ARROW ↓ | Move to the bottom side by 1 field of the sheet. |
| ARROW ← | Move to the left side by 1 field of the sheet. |
| ARROW → | Move to the right side by 1 field of the sheet. |
| CTRL + arrow button | Move to the end of the information area on the sheet. |
| END, arrow button | Moving to a function called “End”. Disabling the function. |
| CTRL+END | Movement to the finished field on the sheet. |
| CTRL+SHIFT+END | Zoom in the marked area to the last applied cell. |
| HOME+SCROLL LOCK | Move to the cell that is located in the upper left corner of the area. |
| PAGE DOWN | Move 1 screen down the sheet. |
| CTRL+PAGE DOWN | Move to another sheet. |
| ALT+PAGE DOWN | Move 1 screen to the right on the sheet. |
| PAGE UP | Move 1 screen up the sheet. |
| ALT+PAGE UP | Move 1 screen to the left on the sheet. |
| CTRL+PAGE UP | Return to the previous sheet. |
| TAB | Move 1 field to the right. |
| ALT+ARROW↓ | Enable a checklist for a field. |
| CTRL+ALT+5 followed by a few TAB presses | Transition between moving shapes (text, pictures, and so on). |
| CTRL + SHIFT | Horizontal scroll. |
Keyboard Shortcuts for the Ribbon
Pressing “ALT” displays combinations of buttons on the toolbar. This is a hint for users who do not yet know all the hotkeys.
Using Access Keys for Ribbon Tabs
| ALL, F | Getting into the “File” section and applying Backstage. |
| ALT, I | Getting into the “Home” section, formatting text or numeric information. |
| EVERYTHING, С | Getting into the “Insert” section and inserting various elements. |
| ALT + P | Getting into the “Page Layout” section. |
| ALT, L | Getting into the “Formulas” section. |
| The ALT + | Access to the “Data” section. |
| ALT + R | Access to the “Reviewers” section. |
| ALT+О | Access to the “View” section. |
Working with ribbon tabs using the keyboard
| F10 or ALT | Select the active section on the toolbar and enable access buttons. |
| SHIFT + TAB | Navigate to ribbon commands. |
| Arrow buttons | Movement in different directions between the components of the tape. |
| ENTER or space | Enable the selected button. |
| ARROW ↓ | Disclosure of the list of the team that we have chosen. |
| ALT+ARROW ↓ | Opening the menu of the button that we have selected. |
| ARROW ↓ | Switch to the next command in the expanded window. |
| CTRL+F1 | Folding or unfolding. |
| SHIFT + F10 | Opening the context menu. |
| ARROW ← | Switch to submenu items. |
Keyboard shortcuts for cell formatting
| Ctrl + B | Enable bold type of information. |
| Ctrl + I | Enable italic type of information. |
| Ctrl + U | Enable underlining. |
| Alt + H + H | Selecting the tint of the text. |
| Alt+H+B | Frame activation. |
| Ctrl + Shift + & | Activation of the contour part. |
| Ctrl + Shift + _ | Turn off frames. |
| Ctrl + 9 | Hide selected lines. |
| Ctrl + 0 | Hide selected columns. |
| Ctrl + 1 | Opens the Format Cells window. |
| Ctrl + 5 | Enable strikethrough. |
| Ctrl + Shift + $ | Use of currency. |
| Ctrl + Shift +% | Using a percentage. |
Keyboard shortcuts in the Paste Special dialog box in Excel 2013
This version of the spreadsheet editor has a special feature called Paste Special.
The following hotkeys are used in this window:
| A | Adding all content. |
| F | Adding formulas. |
| V | Adding values. |
| T | Adding only the original formatting. |
| C | Adding notes and notes. |
| N | Adding scan options. |
| H | Adding formats. |
| X | Adding without borders. |
| W | Adding with original width. |
Keyboard shortcuts for actions and selections
| Shift + ARROW → / ← | Increase the selection field to the right or left. |
| Shift + Space | Selecting the entire line. |
| Ctrl+Space | Selecting the entire column. |
| Ctrl+Shift+Space | Selecting the entire sheet. |
Keyboard shortcuts for working with data, functions, and the formula bar
| F2 | Field change. |
| Shift + F2 | Adding a note. |
| Ctrl + X | Cut out information from the field. |
| Ctrl + C | Copying information from a field. |
| Ctrl + V | Adding information from the field. |
| Ctrl + Alt + V | Opening the “Special Attachment” window. |
| Delete | Removing the filling of the field. |
| Alt + Enter | Inserting a return inside a field. |
| F3 | Adding a field name. |
| Alt + H + D + C | Removing a column. |
| Esc | Cancel entry in a field. |
| Enter | Filling in the input in the field. |
Keyboard shortcuts in Power Pivot
| PKM | Opening the context menu. |
| CTRL + A | Selecting the entire table. |
| CTRL + D | Removing the entire board. |
| CTRL + M | Moving the plate. |
| CTRL + R | Renaming a table. |
| CTRL + S | Save. |
| CTRL + Y | Duplication of the previous procedure. |
| CTRL + Z | Return of the extreme procedure. |
| F5 | Opening the “Go” window. |
Keyboard shortcuts in Office add-ins
| CTRL+SHIFT+F10 | Menu opening. |
| CTRL+SPACE | Disclosure of the field of tasks. |
| CTRL+SPACE and then click on Close | Close the task field. |
Function keys
| F1 | Enable help. |
| F2 | Editing the selected cell. |
| F3 | Move to the “Name at the end” box. |
| F4 | Repeating the previous action. |
| F5 | Go to the “Go” window. |
| F6 | Transition between elements of the table editor. |
| F7 | Opening the “Spelling” window. |
| F8 | Activate extended selection. |
| F9 | Sheet counting. |
| F10 | Activate hints. |
| F11 | Adding a chart. |
| F12 | Go to the “Save As” window. |
Other useful keyboard shortcuts
| Alt+’ | Opens the cell style editing window. |
| BACKSPACE
| Deleting a character. |
| Enter | End of data set. |
| ESC | Cancel set. |
| HOME | Return to the beginning of the sheet or line. |
Conclusion
Of course, there are other hot keys in the spreadsheet editor. We have reviewed the most popular and most used combinations. The use of these keys will help users to work much faster in the spreadsheet editor.