Contents
Microsoft Excel is a very powerful spreadsheet application and is very old – its first version appeared back in 1984. With each new version of Excel, more and more keyboard shortcuts have appeared, and looking at their full list (more than 200!), You can be scared. Don’t panic! 20 or 30 keyboard shortcuts for everyday work will be enough. The rest are for very specific tasks such as writing VBA macros, compiling data, manipulating pivot tables, recalculating large workbooks, and so on.
The most useful keyboard shortcuts in Excel that no workbook can do without
I know I know! These are basic keyboard shortcuts, and many of you know them very well. However, let me write them down for novice users.
Note for beginners: Sign “+” means that the keys must be pressed at the same time. Keys Ctrl и Alt located at the bottom of the main keyboard on the left and right.
| Ctrl + N | Create a new workbook. |
| Ctrl + A | Open an existing book. |
| Ctrl + S | Save active workbook. |
| F12 | Save active workbook with a different name, opens a dialog box Save as (Save as). |
| Ctrl + W | Close the active workbook. |
| Ctrl + C | Copy the contents of the selected cells to the clipboard. |
| Ctrl + X | Cut the contents of the selected cells to the clipboard. |
| Ctrl + V | Paste the contents of the clipboard into the selected cell(s). |
| Ctrl + Z | Undo the last action taken. Panic button! |
| Ctrl + P | Opens a dialog box Print (Seal). |
Data Formatting
| Ctrl + 1 | Opens a dialog box Format Cells (cell format). |
| Ctrl + T | Turns the selected cells into a table. You can select any cell in an adjacent data range, and pressing the combination Ctrl + T will create a table from the range. |
Working with formulas
| Tab | Function name completion. For example, enter “=“, then characters “vl” and press Tab. As a result, you will receive=VLOOKUP(«. |
| F4 | Toggles between different reference type options in a formula. Place the cursor on the cell address and click F4to select the type of link you want: absolute, relative, or mixed (relative column and absolute row, absolute column and relative row). |
| Ctrl+` | Switches display modes for cell values and formulas. |
| Ctrl+’ | Inserts the formula from the cell above into the current cell or into the formula bar. |
| Ctrl + F1 | Show/hide the Excel Ribbon. Hide the Ribbon to display an additional 4 rows of data. |
| Ctrl + Tab | Switch to the next open Excel workbook. |
| Ctrl+PgDown | Switch to the next worksheet. Click Ctrl+PgUpto go to the previous worksheet. |
| Ctrl + G | Opens a dialog box Go to (Transition). The same happens when you click F5. |
| Ctrl + F | Opens a dialog box Find (Find). |
| Home | Returns to the first cell in the current row on the worksheet. |
| Ctrl + Home | Returns to the beginning of the worksheet (cell A1). |
| Ctrl + End | Jump to the last filled cell of the current worksheet, that is, the bottom row of the rightmost column. |
Data input
| F2 | Edit the selected cell. |
| Alt + Enter | In cell edit mode, enter a new line (carriage return) inside the cell. |
| Ctrl +; | Enters the current date. pressing Ctrl+Shift+; enters the current time. |
| Ctrl + Enter | Fills the selected cells with the contents of the current cell Example: select multiple cells. Press and hold Ctrl, click on any of the highlighted cells and press F2 for editing. After that click Ctrl + Enter, and the contents of the edited cell will be copied to all selected cells. |
| Ctrl + D | Copies the contents and format of the first cell in the selected range to the cells below it. If the selected range contains more than one column, then the contents of the top cell are copied down in each column. |
| Ctrl + Shift + V | Opens a dialog box paste Special (Paste Special) when the clipboard is not empty. |
| Ctrl + Y | Repeats the last action if possible. |
Data selection
| Ctrl + A | Selects the entire sheet. If the cursor is currently inside the table, then clicking once will select the table without headings and total rows, a second click will select the entire table, and a third click will select the entire sheet. |
| Ctrl + Home, and then Ctrl + Shift + End | Selects the entire range actually used on the current sheet. |
| Ctrl+Space (space) | Selects the entire column. |
| Shift+Space (space) | Selects the entire line. |
If this article was useful to you, share it with your friends or just leave a comment for me!