Different types of data in excel have different alignments; for numerical data, the default alignment is "aligned to the right horizontally and aligned vertically"; and for text For type data, the default alignment is "aligned to the left horizontally and aligned vertically to the center."
Recommended: "Excel Tutorial"
In Excel, the alignment of data in cells , by default:
Numeric data - aligned to the right in the horizontal direction (normal), aligned in the center in the vertical direction. Such as date, time, numbers used for calculation, etc., are all numeric data, aligned to the right.
Text data - horizontally aligned to the left (normal), vertically aligned to the center. For example, Chinese characters, letters, numbers preceded by an English single quotation mark, etc., are all text data and cannot be used for calculations, so they should be aligned to the left.
Check and compare:
Enter data in the cell and execute the "Format/Cells/Alignment" command. You can see "Horizontal Alignment" and "Vertical Alignment" under the "Text Alignment" column. Align the content in the column. Click the button on the right to choose the alignment yourself.
The above is the detailed content of What is the default alignment in excel. For more information, please follow other related articles on the PHP Chinese website!