ינהאַלט
- איבערבליק
- 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
- פונקציע שליסלען
- Other useful keyboard shortcuts
- סאָף
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.
איבערבליק
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 + קוויטל | Return to the previous field or the last setting in the window. |
| פייַל ↑ | Move to the top side by 1 field of the sheet. |
| פייַל ↓ | Move to the bottom side by 1 field of the sheet. |
| פייַל ← | Move to the left side by 1 field of the sheet. |
| פייַל → | 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. |
| בלאַט אַראָפּ | Move 1 screen down the sheet. |
| CTRL+PAGE DOWN | Move to another sheet. |
| אַלט + בלאַט אַראָפּ | Move 1 screen to the right on the sheet. |
| בלאַט אַרויף | 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. |
| קוויטל | 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). |
| קטרל + יבעררוק | 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 + קוויטל | Navigate to ribbon commands. |
| פייַל קנעפּלעך | Movement in different directions between the components of the tape. |
| ENTER or space | Enable the selected button. |
| פייַל ↓ | Disclosure of the list of the team that we have chosen. |
| ALT+ARROW ↓ | Opening the menu of the button that we have selected. |
| פייַל ↓ | Switch to the next command in the expanded window. |
| קטרל + פקסנומקס | Folding or unfolding. |
| יבעררוק + פ 10 | Opening the context menu. |
| פייַל ← | Switch to submenu items. |
Keyboard shortcuts for cell formatting
| Ctrl + B | Enable bold type of information. |
| קטרל + איך | Enable italic type of information. |
| קטרל + ו | Enable underlining. |
| אַלט + ה + ה | 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. |
| קטרל + שיפט + $ | 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. |
| שיפט + אָרט | Selecting the entire line. |
| קטרל + פּלאַץ | Selecting the entire column. |
| קטרל + שיפט + פּלאַץ | Selecting the entire sheet. |
Keyboard shortcuts for working with data, functions, and the formula bar
| F2 | Field change. |
| שיפט + פקסנומקס | 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. |
| קטרל + אַלט + V. | Opening the “Special Attachment” window. |
| ויסמעקן | Removing the filling of the field. |
| אַלט + אַרייַן | Inserting a return inside a field. |
| F3 | Adding a field name. |
| Alt + H + D + C | Removing a column. |
| עסק | Cancel entry in a field. |
| אַרייַן | Filling in the input in the field. |
Keyboard shortcuts in Power Pivot
| PCM | Opening the context menu. |
| קטרל + א | Selecting the entire table. |
| קטרל + ד | Removing the entire board. |
| קטרל + ב | Moving the plate. |
| קטרל + ר | Renaming a table. |
| קטרל + ד | היט. |
| קטרל + י | Duplication of the previous procedure. |
| קטרל + ז | 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. |
פונקציע שליסלען
| 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. |
| פקסנומקס | Activate hints. |
| פקסנומקס | Adding a chart. |
| פקסנומקס | Go to the “Save As” window. |
Other useful keyboard shortcuts
| Alt+’ | Opens the cell style editing window. |
| BACKSPACE
| Deleting a character. |
| אַרייַן | End of data set. |
| עסק | Cancel set. |
| היים | Return to the beginning of the sheet or line. |
סאָף
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.