Classic shortcut keys that must be remembered absolutely in Excel

Find hidden shortcut keys

So-called "shortcut keys" such as [Ctrl] + [C] [V] can be used by pressing multiple keys at the same time, but cannot be used if you don't remember. In addition to them, it is useful to know that there are shortcuts assigned to many functions.

Press Alt to display letters on a tab or button. In this alphabetical order, you can access the features you want. You can quickly invoke a function even if there are no shortcuts assigned to pressing multiple keys at the same time.

For example, if you want to call the AVERAGE function that calculates the average, press the key in the order [Alt], [M], [U], [A].

Summarizes the functions that can be called from the automatic SUM button. The last key is not easy to remember because it is associated with the function name. Note that the SUM function can be entered in the same way, but I think the [Shift] + [Alt] + [=] key is simpler.

In the Click access Toolbar at the top left of the screen, start from the left [1] [2] [3]. Assign a shortcut key combined with the Alt key. [Alt] + numeric keys can be called, so if you have registered a commonly used feature, please try.

Switching cells to edit mode [F2], [Alt] + [values] that list the values contained in the column are also shortcut keys to improve the efficiency of data entry. The Save as dialog box, which can be displayed in F12, is useful when saving another name. Try to start by memorizing the keyboard shortcuts that you often use to improve your work efficiency.