Like and see, form a habit; Ten years is worth more than a tree.
Wechat search [Yixin Excel] to pay attention to this different we-media person.
In this paper, making github.com/hugogoos/Ex… Has been included, including Excel system learning guide series of articles, as well as a variety of Excel materials.
Check out today’s tips and tricks to turn you into an office cousin.
1. Straddle the line
We use frequently in the process of making table cell centered “combined” function, but it also brings some problems, such as after we put the header “center after the merger”, but we found a column after the need to adjust the location, regardless of whether they are on the shear or mobile can tip “unable to merge cells to perform this operation”.
The solution is also very simple, just select the area to merge cells, and then right click the mouse to bring up the right menu and choose “Set cell format”, or directly press the shortcut key “Ctrl+1” to bring up the set cell format dialog box. Then select the “Align” TAB and set the “Horizontal Align” to “Center across columns”. Not only does it have the same effect as “Center after Merge”, but it also supports cell clipping and movement.
2. The date quickly shifts to weeks
Is there any way you can quickly convert a date to a day of the week without using a function? Yeah, date cell format.
Select the area of cells that you want to convert, bring up the Set cell format dialog box, select the “number” TAB, select “Date” for category, and select “Wednesday” for type.
3. Quick name alignment
In the treatment of the employee information table, employee name length is differ, there are two words, there are three words, there are four words or more, directly in the middle is not beautiful, we just need to select the name cell area, open set the cell format dialog box, set a “horizontal” approach to “scattered alignment (indented)”.
4. Quickly enter the current date and time
You can press the shortcut key Ctrl+; Quickly enter the current date and press Ctrl+Shift+;. Enter the current time quickly.
5. Quickly find and delete duplicate values
We can use conditional formatting to quickly find out duplicate values, only need to select the data area, click on the “start” under the TAB “style” in the command group “conditional formatting” drop-down list of “rules” highlighted cell “duplicates” out duplicate values rules dialog box, select duplicate values and set the highlight style.
To delete duplicate values, you only need to select the data area and click “Delete Duplicate Values” in the “Data Tool” command group under the “Data” TAB.
Small skill big effect, remember to like oh.
Today’s sharing ends here, but the road of learning has just begun, I hope we can keep moving forward on the road of learning, perseverance.
If you are interested in the feature, you can tell xiaobian oh, xiaobian will write a corresponding article for you. Of course, it’s first come, first written. I will make a schedule and try to meet everyone’s needs. So if the next article is not what you want, please don’t worry, it may be the next one. Let me know what you want to learn.
This article continues to update, you can search wechat “yixin Excel” first time to read, this article GitHub github.com/hugogoos/Ex… Excel System Learning Guide series, welcome Star.