How to automatically arrange 123456 columns in excel-excel-php.cn

How to automatically arrange 123456 columns in excel

If you want to get sequential numbers like 1,2,3,4,..., the method is as follows:
1. Form the sequence numbers in the "column" direction
Method 1
Write 1 in the cell------press Enter-----click and hold the small black dot in the lower right corner of the cell, and when the cursor becomes a black cross-----click Hold down the left mouse button and pull down-----select "Fill in sequence" in the menu
How to automatically arrange 123456 columns in excel

Method 2
Write 1 in the cell------Press Enter- ----Click and hold the small black dot in the lower right corner of the cell, and when the cursor becomes a black cross-----Click and hold the right mouse button to pull down-----Select "Fill in sequence" in the menu
How to automatically arrange 123456 columns in excel

Method 3
Write 1 in the previous cell and 2 in the next cell. Select these two cells and click and hold the small black dot in the lower right corner until the cursor becomes a black cross. , click and hold the left button and drag
How to automatically arrange 123456 columns in excel

Method 4
Write 1 in the cell----Edit-----Fill------Sequence---- Generated in the column ----- arithmetic sequence ---- the step size is 1 ---- the termination value is written into the maximum value of the sequence you want, such as writing 1000 ---- OK
How to automatically arrange 123456 columns in excel

Method 5
Suppose you first write 1 in cell A1
and then write the formula in cell A2
=A1 1
Pull down to fill the formula
Method 6
A1 cell Write the formula
=ROW(A1)
Drop-down filling formula
2. Form the sequence number in the "row" direction
Method 1
Write the number 1 in the cell---Press Enter Then --- click and hold the small black dot in the lower right corner of the cell. When the cursor becomes a black cross --- click and hold the left mouse button and pull right --- select "Fill in sequence" in the menu.
How to automatically arrange 123456 columns in excel

Method 2
Write 1 in the cell---press Enter---click and hold the small black dot in the lower right corner of the cell until the cursor becomes a black cross--- Click and hold the right mouse button and pull down---select "Fill in sequence" in the menu.
Method 3
Write 1 in the previous cell and 2 in the next cell. Select these two cells and click on the small black dot in the lower right corner. When the cursor becomes a black cross, click Hold down the left button and drag right.
Method 4
Write 1 in the cell---Edit---Fill---Sequence---Generate in row---Arithmetic sequence---Step size is 1---Terminal value Write the maximum value of the sequence you want, such as writing 1000---OK.
Method 5
Suppose you first write 1
in cell A1 and then write the formula in cell B1
=A1 1
Pull right to fill in the formula
Method 6
A1 Write the formula in the cell
=COLUMN(A1)
Pull right to fill in the formula

The above is the detailed content of How to automatically arrange 123456 columns in excel. For more information, please follow other related articles on the PHP Chinese website!