In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >
Share
Shulou(Shulou.com)11/24 Report--
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
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.