Numbering in Excel
Numbering the data in an Excel spreadsheet is very necessary, instead of having to enter the numbers from the beginning to the end, you can do some quick operations to automatically number the order. self for Excel spreadsheet.
The article shows you 2 ways to automatically numbered in Excel.
Method 1
Step 1: You enter the first order number in the first position to number. You can enter the first number you want to start with, for example: 1 (can be 2, 3 or any number).
Step 2: Select the box you just entered the first order and select the tab Home on the toolbar. In the Editing section you choose Fill -> Series .
Step 3: Series dialog box appears , you set some options:
Series in: in Series has 2 options, you select Rows if you want to number by the row, select Columns if you want to number by the column.
Type: There are 4 options:
- Linear: numbering in ascending fashion.
- Growth: numbered in a progressive manner.
- Date: type of date.
- AutoFill: autofill type.
To number by ascending order you select Linear .
Step value: enter the space between two sequence numbers (hops). For example, if you enter 1, the sequence number will be 1, 2, 3 . if you enter 2, the ordinal number will be 1, 3, 5 .
Stop value: enter the last value, the stop number. For example, if you only want to number from 1 to 10, then you enter 10 in the Stop value box .
After making your selection, click OK .
You will then get the following result:
Method 2
Step 1: You enter at least the first 2 consecutive numbers.
- If you want to type in the column, then you enter 2 numbers according to the column.
- If you want to number by the line you enter 2 numbers in line.
- If you want to sequentially increase by one unit, you enter 2 numbers 1 unit apart, if you want to number each other, how many units you enter 2 numbers, respectively.
Step 2: You select (black out) 2 consecutive numbered boxes, then move the mouse to the bottom right corner position to appear the cursor in the form of the + sign as shown below:
Step 3: When the mouse pointer appears as you hold down the mouse, drag the mouse to the last position to be numbered.
Step 4: Release the mouse and the result is as follows:
So just with very simple manipulations, you quickly numbered all the data in Excel spreadsheets. Good luck!
You should read it
- Page numbering method of type 1/2 in Excel
- Instructions for numbering in Excel
- Page numbering in Excel does not start with number 1
- Instructions to stamp negative numbers in Excel
- How to number pages in all versions Excel (update 2020)
- Numbering pages in Excel
- Page numbering in Excel does not start from 1
- Instructions for numbering in Word tables
May be interested
- Instructions for numbering in Word tablesthere is no automatic numbering feature available in excel. when you want to number in a word table, you need to use the numbering feature in word.
- Page numbering steps in Microsoft Word Microsoftpage numbering in microsoft word is a basic and very simple operation when you work with documents. for those who often have to print references, manuals, and textbooks, creating page numbers will help viewers find content faster, through the table of contents in word.
- How to insert page numbers in Excelpage numbering in excel differs from page numbering in word, we will need to customize the page setup group in excel.
- How to number pages in Word 2007page numbering on word is a basic operation and is often done, making the document more intuitive and scientific.
- How to type pages in Word 2010when numbering pages in word 2010, especially when making dissertation reports, references, guidelines will make the document easier to see and scientific.
- Page numbering in Powerpointare you looking for page numbering in powerpoint, single or multiple page numbering in powerpoint? here tipsmake.vn will share to you how to page numbering in powerpoint, invite you to track and learn offline.
- Number pages in Word 2003, insert special characters, date and time into Wordpage numbering in word 2003 makes it easy to set up automatic indexing, find the content you need quickly. this is the simplest page numbering guide on word 2003.
- 8 ways to number Excel numbers, number Excel numbers with texton excel, there is an automatic column numbering feature, users will no longer need to drag cells in order as usual.
- How to Number Pages in Canvapage numbering in canva makes it easier for users to follow and shows professionalism when you create presentation slides in canva.
- MS Excel 2003 - Lesson 3: Manipulating data in spreadsheetsthe previous article tipsmake.com has guided you to some basic formatting for a small data area, but if you need to format a large area or the default format for a new excel 2003 file, follow these instructions.