Three excel table tips, so that you do not have to worry about simple office
Written expression 2020-11-26 09:12:54
I have a friend , I was scolded by my boss at work . The leader asked him to be a Excel form , Finish before work , My friend vowed that there was no problem , As a result, I didn't finish it after work , Not only was he scolded by his boss , And asked to stay and work overtime .



 Three Excel Form tips , Let you work simply without worry


Why does this happen ? Or to blame my friends for not being good at learning , Yes Excel There is no good understanding of . Friends say , I've been looking for features , But it's turning the mouse , But I don't know where , It's time to get off work .


Actually Excel A lot of operations are in 2-3 It can be done in seconds , such as Excel Auto fill of , Make a drop-down list , Special paste and other functions , Daily operation is common .


Here are some operations , Have a strong skill , Don't waste time on unnecessary operations .


1. Fill in the same content



 Three Excel Form tips , Let you work simply without worry


Two common ways to fill in the same content :


The first one is , Select a range of cells , Input content , Press shortcut key Ctrl+Enter Press the key .

The second kind , Select the first cell , Input content , Double click the cell handle to fill in .


2. Fill in the serial number



 Three Excel Form tips , Let you work simply without worry


There are two practical filling methods :


The first one is , Select the first cell and enter it as required 01, Double click the handle to complete the filling . But this method has one drawback , When you enter add and delete records , Need doesn't automatically update .

The second kind , Use Row Function to fill in the ordinal number , fill “=Row()-1”, Double click the cell handle to complete the filling . And when we delete or add content , It will update automatically .


3. Forced line wrap



 Three Excel Form tips , Let you work simply without worry


When we fill in the cells , Press Enter The key does not wrap , And it will jump to the next cell . So a lot of people use a stupid way , That's to keep pressing the space , To achieve the effect of line break .


In fact, this operation is very simple , You just need to hold down the shortcut key before the newline character Alt+Enter that will do .


In fact, many operations are very simple , It's just that we didn't really learn , Now you know what's wrong ?


Last but not least , That man is really my friend , Is not my .

版权声明
本文为[Written expression]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/20201126090958233g.html
相似文章

2021-08-09