Master’s computer operation is sometimes too fast to follow with eyes. The feature is that it uses a lot of keyboards, and the combination of mouse and keys is also excellent. Let’s master it too. Not only the operation method but also the efficient memorization method will be taught 5 times in “App Edition”. It is a guarantee that if you wear it, you will be able to make a fool of yourself with your colleagues at work.
◇ ◇ ◇
How to use Excel varies from person to person. While there are power users who handle huge tables and dozens of sheets, there are also those who only make a simple tabulation of one A4 sheet. To meet these diverse needs, Excel offers a variety of shortcut keys.Figure 1I showed only a few of them, but there are many and I can’t find a convenient way to remember them. With “Get used to it rather than learn”, replace the usual operations with shortcut keys one by one, and let’s get used to it repeatedly.
Format cell ranges, shapes, and graphs with “Ctrl” + “1”
The first thing I want to remember is how to open “Formatting ◯◯”. The quickest way is to select the target and press the “Ctrl” + “1” keys (Figure 2). It can be used not only for cell ranges but also for graphs and figures.
Figure 2 Select a cell or range of cells and press Ctrl + 1 to open the Format Cell screen (1-3). Tabs such as “Display format” and “Arrangement” can be moved with the “→” and “←” keys (4).It does not work with “1” on the numeric keypad, but it is also effective for figures and graphs.