Useful tips for Excel cell formatting

Source: Internet
Author: User

In Excel tables, there are a lot of tricks that we don't know or don't use, and working with tables is the most common gadget for us to learn and work with. Excel tools are mainly used in WPS and Office software, we can use any of them to open the table, learning and constantly practice Excel to speed up our work efficiency.

Use one: Segment display mobile phone number

1, we open Excel input name and mobile phone number (this demo is false), and then all selected mobile phone number part, I am here "b1-b4" area. Then we can open the cell formatting interface by clicking the triangle arrow in the lower-right corner of the Font tab of the Start menu.

2, open cell format there are two of the most common, one is all the selected areas right-click to select Format cells, and the second is the small arrow in the lower-right corner of the "Number" tab in the Start menu, and you can open the cell format and manipulate the number interface.

3, we click on the "Number" screen to select "Custom", and then we enter the "type" inside the format of the 000-0000-0000, is our mobile phone number of 11-digit display format. Enter the completion of the click "OK" on it, let's take a look at the effect of the diagram below ~

Usage Two: The data is displayed in million units

1, the number of display we are using any one of the above to open the cell, I am here directly using the shortcut keys or right click on the "Format cell formatting" Open, and then in the "digital" interface. To open a cell formatting shortcut key: ctrl+1

2, then, we choose the "custom" digital mode, in the right type inside the input 0!. 0, "million" (Pinyin input status), click "OK" after we can see the effect of the ~


The cell formatting of Excel uses tips to help us do different digital display modes.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.