Check out the efficient shortcuts related to Alt key in Excel

Original title: "if you can use the Alt key in Excel, why do you have to work late into the night?" "

I believe students know that when using Excel, shortcut keys and mouse "double swords", the work efficiency will increase exponentially.

But there are so many keyboard shortcuts in Excel, do you have to remember them?

NONONO, in fact, most of the shortcut keys of Excel are related to [Ctrl], [Shift] and [Alt].

And some keyboard shortcuts are not very commonly used, while others are used very frequently, such as [Alt] to fit the picture to the border, [Alt+F4] to quickly close the workbook, and so on.

Today, let's talk about the efficient shortcuts related to the [Alt] key.

One-click summation selects data regions-- use the shortcut key [Alt+=] to quickly sum

Quickly generate chart selected data area-- [Alt+F1] quickly generate chart

Turn the page and browse through many data columns. Use the shortcut key [Alt+pg down] to turn the page to the right and [Alt+pg up] to turn the page to the left.

When the text in the newline display cell needs to wrap, you can use [Alt + enter].

Selectively paste the selected data area-- copy the data-- press and hold the [Alt], [E], [S] keys in turn to bring up the selective paste interface.

What do you think? do you remember everything after reading it?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Chang Xiaoan, Editor: Zhu Lan