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
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
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
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 .