In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
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()
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.