Excel application skills: Ctrl + Shift combination usage, excel application skills

Source: Internet
Author: User

Excel application skills: Ctrl + Shift combination usage, excel application skills

Today, xyz introduced the Excel application skills! At work, we often encounter the need to select or clear a part of the data in the table. I believe that many newcomers in the workplace use the mouse to drag the selection, in fact, you can use Ctrl + Shift + key combination to quickly complete.


Usage 1: Ctrl + Shift + → and ← press Ctrl + Shift, and then press → and then you can select a region in one second.


Usage 2: When the sum formula selects the reference area, you do not need to drag the cursor down. Press Ctrl + Shift.


Usage 3: another shortcut for partial selection: You can select a part of a row/column and press Shift to double-click the lower line/right line.


Usage 4: the premise for the above two methods to quickly select some areas is that there are no blank rows in the table. What should I do if there are many blank rows in the table? At this time, you can press Ctrl + Shift + End to quickly select

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.