Excel’s list of shortcuts to remember absolutely [with practice function]
Excel is a very popular tool in business.
I’ve put together a set of shortcuts that you definitely want to remember. Those who work with Excel every day should learn shortcuts as soon as possible. Let’s learn early and let’s say goodbye to the wasteful work that we used to do with the mouse.
It’s important not only to learn shortcuts with your head, but also with your body. This site can be practiced intuitively, so please try the following practice first. And we recommend that you practice regularly on this site.
A detailed explanation list of each shortcut is given at the bottom.
First of all, please practice by actually moving your hands.
The exercises below include all Excel exercises. If you want to practice by dividing by genre, please select a menu from the items in “TRAINING” on this site and practice.
The following shortcuts are too general, and many people already know them. If you do not know it, please wear it immediately. You’ve been doing a lot of wasted work up to now. If you didn’t know this shortcut, you would have lost 5 seconds per task. If you were to repeat this 50 times a day…how many seconds would you lose per year? ?
|Save the book||WindowsCtrls|
It is a shortcut to return to the previous state. Commonly known shortcuts, which are often the same commands in other applications.
In case of Excel, you can trace the past of edit history by repeating this command.
Please note that the history will not be reset even if you execute overwriting, but if you close the book once and reopen it, the edit history will be reset.
This may be the most common shortcut. In the case of Excel, the behavior is slightly different between the cell selection mode and the cell editing mode.
In the cell selection mode, the format information in the cell is also acquired. In the edit mode in the cell, it is possible to edit without being affected by the format, so it is necessary to use it properly depending on the situation.
This is a very popular shortcut to display a search and replace dialog. You can also set options such as scope, search direction, and search target.
If you execute search or replace with the selected range specified, you can search only in the selected range, so it is necessary to use them properly depending on the situation. ‥
Break in the same cell
This shortcut should be very troublesome if you do not know it. If you try to start a new line with just the Enter key while in edit mode in a cell, you will exit edit mode and select the cell below. This shortcut is required if you want to break lines in cells.
|Break in the same cell||WindowsaltEnter|
Edit text (bold, italic, underline, strikethrough)
If you remember, it is a text decoration type shortcut that can be edited at explosive speed. The behavior is different when the cell itself is selected and when individual characters are selected in cell edit mode.
When the cell itself is selected, it is applied to all the characters in the cell. On the contrary, when individual character is selected in cell edit mode, it is applied only to the selected character.
It is surprisingly convenient to know the shortcut for moving cells. The key point is that this shortcut is where you can move cells without taking your finger off the home position. Remember, you will be able to work without stress.
Shortcut to hide rows and columns. You can select a row or column for each row, right-click and select “Do not display” with a single command. Remember, it will definitely streamline your work. ‥
|Hide cursor “row”||WindowsCtrl9|
|Hide cursor “column”||WindowsCtrl0|
Shortcut for expanding a cell selection. Use this when you want to edit multiple cells.
|Extend the selection up one level.||Windowsshift↑|
|Extend the selection one place to the right.||Windowsshift→|
|Extend the selection down one level.||Windowsshift↓|
|Extend the selection one place to the left.||Windowsshift←|
Move to the end in the data area
It is a shortcut that can move to the edge in the data area. When moving from a place with a value, it moves to the edge of the cell with a value, and when moving from a place without a value, it moves all the way to the edge of the cell with no value.
|Move to the first row in the current data area||WindowsCtrl↑|
|Move to the leftmost column in the current data area||WindowsCtrl←|
|Move to the last line in the current data area||WindowsCtrl↓|
|Move to the rightmost column in the current data area||WindowsCtrl→|
Select to the edge within the data area
It is an application of the above shortcut. Shortcut used when you want to extend the selection to the edge of the data area.
|Extend selection to the first row in the current data area||WindowsCtrlshift↑|
|Extend selection to the leftmost column in the current data area||WindowsCtrlshift←|
|Extend selection to the last row in the current data area||WindowsCtrlshift↓|
|Extend selection to the rightmost column in the current data area||WindowsCtrlshift→|
Open list of validation rule options
Normally, for cells with selection items, press the ▼ button with the mouse to display a selection list, but using this shortcut you can select without using the mouse. Please remember that working without a mouse can reduce work stress.
|Open list of validation rule options||Windowsalt↓|
Open Cell Format dialog
Shortcut for opening a dialog that allows you to format cells such as “number”, “currency”, and “string”. Even after the dialog is displayed, you can select it with the arrow keys and press ENTER to confirm it, so you can change the format without using the mouse.
|Open Cell Format dialog box||WindowsCtrl1|
Edit active cell and move cursor to end of cell content
When you want to edit the text in the cell, it is a shortcut that you can immediately enter edit mode. If you want to edit the contents of a cell, you can use this shortcut to save one action. It’s a shortcut that you should definitely remember because it will increase the work efficiency considerably.
If you select with this shortcut, the backmost one will be active, so you can add characters immediately.
|Edit active cell and move cursor to end of cell content||WindowsF2|
Open [Insert] or [Delete] dialog
The behavior of this shortcut changes depending on the status of the selected cell. If you have selected one or more cells, a dialog box will appear, but if you have selected all rows or columns, a blank line will be added or deleted without displaying the dialog box. ..
|Open Insert dialog||WindowsCtrlshift「+」|
|Open the Delete dialog||WindowsCtrl「-」|
Extend selection to “column” or “row”
A shortcut that extends the selection to the entire column or row from the current cursor. After selecting all columns/rows, you can add or delete them by using the shortcuts of “Insert” and “Delete” above, so remember them as a set.
|Extend the selection to the entire column.||WindowsCtrlspace|
|Extend the selection to the entire row.||Windowsshiftspace|
Add or remove blank columns with Columns or Rows selected
As mentioned above, if you use the shortcuts of “Insert” and “Delete” with the column or row selected, you can perform the operations of “Insert” and “Delete” as they are. Very convenient to remember.
If you add a row/column while copying/cutting by row/column, the contents of copy/cut will be inserted as is.
|[With columns or rows selected] Add a blank column||WindowsCtrlshift「+」|
|[With columns or rows selected] Delete blank rows||WindowsCtrl「-」|
[Select format and paste] Open dialog
This is a shortcut for selecting the format when pasting the information copied from another cell. Knowing this is faster than pasting and then choosing a format.
|[Select format and paste] Open dialog||WindowsCtrlaltv|
If possible, repeat the previous command or operation.
This is a shortcut that allows you to repeat special actions such as “Combine cells to center”. Very useful when you want to perform the same action in multiple places.
|[If possible] Repeat the previous command or operation.||WindowsCtrly|
Apply/remove outer borders to selected cells
A shortcut to add or remove borders from the outline of the selected cell. If you have selected multiple cells, the border will be added only to the outer frame.
If the outer border has already been applied, the behavior is to delete the border.
|Apply outline border to selected cells||WindowsCtrlshift&|
Switch between sheets in a book
This is a shortcut to switch between sheets separated by tabs at the bottom of the same book (file). Remember, you don’t have to click the tabs at the bottom to switch.
|Select the next sheet in the book.||WindowsCtrlshiftpagedown|
|Select the previous sheet in the book.||WindowsCtrlshiftPageUp|
Expand or collapse the formula bar.
This is a shortcut to switch the upper box for editing the cell contents from one line to multiple lines. If it is displayed in multiple lines, it will be toggled to one line.
|Expand or collapse the formula bar.||WindowsCtrlshiftu|
Use Copy Down to copy the cell content and formatting one level above to the cells in the selection.
A shortcut to copy the contents and format of the cell above. If a single cell is selected, the cell contents and format above it will be copied, and if multiple cells are selected, it will be applied within that range.
|Use Copy Down to copy the cell content and formatting one level above to the cells in the selection.||WindowsCtrld|
Switch cell format
It is a shortcut to directly convert each format such as currency and percentage. It can be converted without going through a dialog, so if you remember it, the work will progress considerably.
|Apply the Currency display format.||WindowsCtrlshift$|
|Apply the Percentage display format.||WindowsCtrlshift%|
|Apply the Date format for dates, months, and years.||WindowsCtrlshift#|
Open the Insert Hyperlink dialog.
Shortcut to open the dialog used when inserting a link. Normally, you need to right-click a cell and select it from the context menu, but you can use the shortcut to open the dialog immediately.
|Open the Insert Hyperlink dialog.||WindowsCtrlk|
Check the worksheet you are working on or the spelling in the selected range.
Shortcut to check spelling only for English. If no selection is specified, the worksheet you are working on will be checked. If you have specified a selection, the spelling will be checked in that range.
|Check the worksheet you are working on or the spelling in the selected range.||WindowsF7|
Enter the current time and date
It is a shortcut that automatically inputs the current time and date. The format is also automatically dated, which is convenient.
|Enter the current time||WindowsCtrl:|
|Enter the current date||WindowsCtrl;|
Add a cell comment.
This is a shortcut that allows you to enter a comment to a cell immediately. This is useful when you use comments for the description of the sheet.
|Add a cell comment.||WindowsshiftF2|
Create an embedded graph from the selected range of data.
It is a shortcut to automatically generate a graph based on the selected range of data. You may not use it very often, but in case of emergency, you can quickly create a graph.
|Create an embedded graph from the selected range of data.||WindowsaltF1|
This is a convenient shortcut for those who work with macros in VBA.
|Create, run, edit, or delete macros.||WindowsaltF8|
|Open the Microsoft Visual Basic For Applications editor.||WindowsaltF11|