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

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.