Excel will not be out on the CTRL key, common seven shortcut Ctrl, efficient completion of the work
Hulan River legend 2021-02-22 22:45:24

Speaking of Excel Shortcut key , It can efficiently complete all kinds of our daily work .Excel The most frequently used shortcut key operation in , is Ctrl Shortcut key . This shortcut key with other keys can achieve a very versatile operation . Now let's go through the actual case , Learn how to put shortcut keys Ctrl Apply it to our work .

Case a :Ctrl Shortcut key for content input of multiple cells at the same time


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : We need to be in many cells , Enter the same character content at the same time : Colleague two words . You can use Ctrl+Enter Key combination realizes .

Operation skills :

1、 First, select the cell range where we need to input text , Click the formula window to enter : colleagues , Then press the shortcut key Ctrl+Enter End of key combination , So all cells will be filled with the same content .

Case 2 :Ctrl Key to quickly adjust the display size of the current table window


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : Our current table shows that when the data is small , We can use Ctrl Key to adjust the scale of the current window .

Operation skills :

1、 according to Ctrl The key doesn't move , Then slide the slide button on the top of the mouse . You can slide up and down to zoom the currently displayed window scale .

Case three :Ctrl Key to fully display the formula content corresponding to the current cell


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : In the current range of cells , We need to get the percentage value , Check the corresponding calculation formula , You can use Ctrl Shortcut key .

Operation skills :

1、 Click on the value of any calculated result , Then press the shortcut key Ctrl+`, It's on the keyboard 1 The special symbol on the left . So you can see all the formulas , We press it again and it will go back to the original state .

Case four :Ctrl Key quickly drag copy data paste as picture


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : We need to use Ctrl Key to quickly copy new data content .

Operation skills :

1、 The mouse selects all the data areas that need to be copied , Then press and hold the shortcut key Ctrl, Put the mouse on the border when the cross appears , We can drag it to create a new area .

Case 5 :Ctrl+D Key to quickly fill down the data 、Ctrl+R Quickly fill data to the right


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : When there is already a data area , We need to quickly copy and paste data down and right . It can be used here Ctrl+D and +R To achieve .

Operation skills :

1、 Select the cell below the data with the mouse , Press Ctrl+D You can quickly fill in the top cell below ; Select the cell to the right of the data with the mouse , Press Ctrl+R You can quickly fill in the cell contents on the right side of the data .

Case 6 : Quickly extract people's names from names and numbers


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : We need to have names and numbers in parentheses in the data , Quickly extract the names of the people we need . Here use Ctrl+H It can be operated in the way of substitution .

Operation skills :

1、 Because there's a clear pattern in the data , That is, numbers are all enclosed in brackets . So here we press Ctrl+H Enter the search and replace interface . Find content input (*), Replace the content without modification . In this way, the parentheses and all the contents in them can be replaced with null values at one time .* Is a wildcard for any value .

Case seven :Ctrl+G Fast formula query for discontinuous cells


Excel Can't Ctrl Key on out 了 , Seven common Ctrl shortcuts , Get the job done efficiently

Case description : We need to use vlookup Function to query the corresponding data , But you can't override the original value . And that's where it comes in Ctrl+G The function of positioning conditions .

Operation skills :

1、 Select the corresponding sales area with the mouse , Then press the shortcut key Ctrl+G, Select null value for positioning condition , This allows you to select cells that are not populated with data ;

2、 After selection, we put the mouse on the formula bar and input the query function , Then press Ctrl+Enter Enter to end , In this way, you can fill the currently selected cells with functions , Without affecting the original data .

Excel in Ctrl The function of shortcut key is very powerful , We can use shortcut keys to achieve many efficient operations in different situations , Now have you learned ?

版权声明
本文为[Hulan River legend]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210222113159840h.html
相似文章

2021-08-09