Mid-Year Promotion Offer, Life Membership Discount 70 Yuan
Support WeChat public account + applet + APP + PC website multi-platform learning
The Ctrl family is the most common excel usage in the workplace. For example, Ctrl+C is to copy, Ctrl+V to paste, Ctrl+Z to undo, and Ctrl+X to cut. Familiar with the usage of shortcut keys is to improve work. The first step to efficiency . So, in addition to these commonly used shortcut keys, there are also some less commonly used shortcut keys, such as the shortcut key Ctrl+R , are you familiar with the cute door? What an amazing function.
Let's first introduce, the essence of Ctrl+R is a shortcut key for filling to the right, so we can also find it in the "Start" tab of the menu bar.
Let's do it in action.
The above is the salary statistics table of a certain department. Now the leader asks the editor to separate statistics according to men and women. What should I do? Copying and pasting one by one is too slow . If there is less data, it is fine. If there is too much data, then you will have to vomit blood and organize, and you will be exhausted. And, most importantly, there will be bugs.
The reason for the above problem is that Excel is not completely intelligent after all, and there will be interlacing when filtering, so Excel cannot fully recognize it. So it's better to try Ctrl+R , filter on the collocation, you can save a lot of unnecessary workload.
Click "Filter" in the menu bar → first select the gender of "male" → select the data source area → press and hold Ctrl to select the target area → finally press Ctrl+R at the same time, then select the gender of "female", and continue the above operation .
PS: The data source area and the target area must be on the same line or the same lines, otherwise the operation will fail.
After all, no gold is bare, and no one is perfect. This is no exception when used in Excel. For this defect of Ctrl+R, we can use this in conjunction with skipping blank lines in Paste Special. This problem Also solved.
That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.
★ FAQ ★
①Xiao Ai: Can you watch all the courses after buying VIP ?
Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)
②Xiao Ai: Hello, how do you study ?
Pay attention to the Aizhiqu Education service account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!
Computer login to https://www.92zhiqu.com
(Mobile phone, computer learning is essential)
③Xiao Ai: what to do if you do n’t understand
Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)
④Xiao Ai: Provide video courseware materials ?
Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)
⑤Classmate Xiao Ai: Validity period of study ?
Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)
⑥ Primary school students: Does the website support accelerated viewing ?
kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback
⑦ Does the course support offline download ?
kindness. Both Android and Apple IOS APP support mobile phone offline download
Computer downloads are provided by contacting WeChat customer service 18074746783.
⑧ How about the quality of the course ?
Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition
If there is anything else you need to consult, please contact WeChat customer service 18074746783
Long press to identify the QR code "Add Customer Service"
