What are the excel skills that can improve your productivity?

This article is to share with you about excel skills that can improve productivity. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

1.#######in cell

I believe that you often encounter this situation when making tables, so what is this problem?

In fact, ah, because our cells can not accommodate the input content, then we only need to adjust the column width of the next cell can!

2. Enter more than 15 digits

In the form often to enter some long numbers, such as ID card number, bank card number, etc., but when we enter such a long number in the cell will be displayed in the form of scientific notation, and the number behind the 15 digits has become 0.

In order to make these numbers appear correctly, we can only set the cell to text format before entering, or enter an English single quotation mark before entering.

3. Split Multiple Lines by Number of Characters

Excel column tool can be achieved by the number of characters split columns, but what if we want to achieve the number of characters split rows?

As follows, you need to split into multiple rows according to two characters. First adjust the column width to accommodate two characters, and then select Column A. Click Start Tab-Fill-Content Rearrangement

4. Quickly identify duplicate values

Select Column A Data Click Start tab-Conditional formatting-Highlight cells Rule-Duplicate values.

5. expiration reminder

Set automatic reminder seven days in advance of contract expiration, select the date area in column B, click Condition Format-New Rule-Use Formula to set the format of the cell, formula input: =$B2-TODAY()