But there's a problem . Many netizens reported that , Just a few words of online communication , Sometimes I really can't understand things , Clear and definite Excel form 、 Diagram became the most useful reporting method in this period .
however Excel It takes a lot of time and energy to make the form , So Xiao Bian sorted out the following Excel The practical operation method of , I'm sure it will help you improve your efficiency 、 Saving time ！
01 Add more than one line at a time
Quickly insert blank lines
?? Specific operation steps ：
First, select a column of data , Move the cursor to the lower left corner , When the cursor changes to “ Ten ” when , Press 【Shift】+ Left mouse button （ The cursor changes ）, Just drag it down . Drag and drop 2 That's ok , Just insert 2 Go ahead, go ahead ！ And so on .
02 Quickly filter out the Yellow cells
?? Specific operation steps ：
【Ctrl】+【F】—— Options —— Format —— fill —— It's yellow —— Find all —— Press down 【Shift】 key , Check all data —— close —— Click on the pigment bucket and fill it in red .
03 Jump quickly to the last line
?? Specific operation steps ：
Click on any cell , Mouse over the border of the cell , Double click the bottom border , Quickly navigate to the last line ; Double click the right border , Quickly navigate to the rightmost column ; Double click the top border , Quickly navigate to the first line ; Double click the left border , Then quickly locate to the far left .
04 The data is quickly inserted into the desired column
?? Specific operation steps ：
Want to put “ Place of sale ” Put it in “ Product name ” after ： Choose D Column , Press 【Shift】, At the same time, you can quickly switch column data by dragging with the left mouse button .
05 Find the most appropriate column
?? Specific operation steps ：
After selecting the data , Place the cursor between the lists , When the cursor changes into a two-way arrow , Double click to get the most appropriate width column .
06 Separated empty cells
Quickly fill in the same content
?? Specific operation steps ：
【Ctrl】+【G】 After quickly selecting the space , After entering the content , Press 【Ctrl】+【Enter】 that will do .
07 Wrap in cell
?? Specific operation steps ：
By entering spaces and column widths , To control line feed . It's actually a lot of spaces , It's a hidden danger for future data processing ！ In fact, according to 【Alt】+【Enter】 You can wrap lines in cells .
08 Quickly copy the previous line
?? Specific operation steps ：
A lot of people think about replication 【Ctrl】 +【C】,【Ctrl】 +【V】, This method is very troublesome to deal with a large number of text data , Drag a line of blank cells with the mouse , And then just press 【Ctrl】+【D】, You can do a quick copy .
09 The column width remains unchanged after the table is copied
?? Specific operation steps ：
After copying and pasting the form , Click on the bottom right corner of the form , choice 【 Keep the source column width 】, As like as two peas, the new form is the same as the original , Simple 、 quick 、 Efficient ！
10、 Set the number of digits
?? Specific operation steps ：
Select a cell —— Right click —— Format cell —— Customize —— Enter placeholders 0 that will do （ If you need three digits , Input 3 individual 0 that will do ）.
You can find , No matter what the input is 1 The number of digits is still 2 digit , Will be automatically completed to 3 digit ！
The source of this paper is ： gta , Microsoft Excel Certified Professional , The author of 《 Competitive power ： Play in the workplace Excel, Never work overtime 》.
Excel Good use , Work with less trouble , Try to operate it 10 A little trick of you , Does it also send out “ Why didn't you know that ？”. Then use it quickly ！