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.

Open/Close/Save Book

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? ?

Undo

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.

Copy/Paste/Cut

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.

Find/Replace

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.

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.

Move cell

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.

Hide rows/columns

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. ‥

Extend selection

Shortcut for expanding a cell selection. Use this when you want to edit multiple cells.

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.

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.

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 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.

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.

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. ..

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.

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.

[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.

0

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

“

Macro shortcuts

This is a convenient shortcut for those who work with macros in VBA.