Home >Topics >excel >How to align characters and numerical data in cells by default

How to align characters and numerical data in cells by default

藏色散人
藏色散人Original
2020-07-02 11:42:1517535browse

By default, the character data in the cell is left-aligned and the numerical data is right-aligned. The viewing method is: first enter a set of text content in the excel table; then enter the numerical data in the blank cell ; Finally, click Enter to see the default alignment.

How to align characters and numerical data in cells by default

By default, character data in a cell is left aligned, and numeric data right aligned.

Viewing method:

1. First, enter a set of text content in the open excel table. After clicking Enter, you can see that the default alignment is left aligned.

How to align characters and numerical data in cells by default

#2. Then enter numerical data in the blank cell and click Enter to see that the default alignment is right-aligned.

How to align characters and numerical data in cells by default

3. If you need to change different alignments to a unified alignment, you can select the text and value cells and find the alignment column in the "Home" tab. .

How to align characters and numerical data in cells by default

#4. For example, click on Center Alignment to uniformly set the selected cell contents to center alignment.

How to align characters and numerical data in cells by default

Recommended: "Excel Tutorial"

The above is the detailed content of How to align characters and numerical data in cells by default. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn