Home >
Article > Topics > How to automatically arrange 123456 columns in excel
How to automatically arrange 123456 columns in excel
silencementOriginal
2019-06-15 10:25:1731898browse
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
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
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
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
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.
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!
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