How does excel make a table? Telecommuting is more efficient
Glutinous rice 2021-02-22 23:59:04
I believe that we have started work one after another in the past two days , Many enterprises in order to control personnel aggregation , Chose the short-term telecommuting mode .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 .

Excel How to make a form ? Telecommuting is more efficient


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 !

Excel How to make a form ? Telecommuting is more 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 !

Excel How to make a form ? Telecommuting is more efficient


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 !
版权声明
本文为[Glutinous rice]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210222151905168c.html
相似文章

2021-08-09