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.