What are the default alignments in excel?

The default alignment methods in excel are: 1. Numerical data, aligned to the right in the horizontal direction, and centered in the vertical direction; 2. Text data, aligned to the left in the horizontal direction, and centered in the vertical direction.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The default alignment in excel is:

In Excel, the alignment of data in cells, by default:

Numeric type Data - aligned to the right horizontally (regular), aligned vertically to the center. 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.

Extended information:

Basic knowledge of Excel

1. In Excel, the default value of the newly generated workbook window There are 3 worksheets.

2. In Excel, the worksheet can be divided into 65536 horizontal rows (Row) and 256 columns (Co1umn). The row numbers use Arabic numerals 1-65536 and the column numbers use English letters A-IV.

3. In Excel, the worksheet file extension is xls and the chart file extension is xld.

4. In Excel, the rectangular blank space in the worksheet, where text and formulas are entered, is called a cell.

5. In Excel, absolute addresses are marked with $.

6. In Excel, "A2 A3 B5" is represented by absolute address as "$A$2 $A$3 $B$5".

7. In Excel, range addresses are separated by colon.

8. In Excel, the name of the first worksheet in the workbook is conventionally sheet1.

Related learning recommendations:excel tutorial

The above is the detailed content of What are the default alignments in excel?. For more information, please follow other related articles on the PHP Chinese website!