HomeApplicationOffice informationNumbering in Excel

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).

Numbering in Excel Picture 1

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 .

Numbering in Excel Picture 2

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 .

Numbering in Excel Picture 3

You will then get the following result:

Numbering in Excel Picture 4

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.

Numbering in Excel Picture 5

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:

Numbering in Excel Picture 6

Step 3: When the mouse pointer appears as you hold down the mouse, drag the mouse to the last position to be numbered.

Numbering in Excel Picture 7

Step 4: Release the mouse and the result is as follows:

Numbering in Excel Picture 8

So just with very simple manipulations, you quickly numbered all the data in Excel spreadsheets. Good luck!

5 ★ | 1 Vote

You should read it

May be interested

  • How to add rows and columns in ExcelPhoto of How to add rows and columns in Excel
    how to add rows and columns in excel. the article shows you 3 ways to add rows (rows) or add columns in excel.
  • Create Hyperlink in WordPhoto of Create Hyperlink in Word
    in the process of working with word, surely not less or less you will also need to insert website links, e-mail or links to files in your computer to make the text full and complete.
  • Change the background image and background in WordPhoto of Change the background image and background in Word
    default word editor background is white background, you can compose important documents ... but you can change the background to avoid boredom with word's default background or suitable for documents. there is different content.
  • Capture and edit images in WordPhoto of Capture and edit images in Word
    capture and edit images in word - screenshot feature (screenshot) is a new feature in the editor of microsoft word. you can absolutely take screenshots and edit photos right in word.
  • Create Watermark for Word documentsPhoto of Create Watermark for Word documents
    watermark is the image, the text is blurred, or the marker is inserted after the text in the word document. often word editors want to leave a copyright mark for themselves. you can also create your own verification mark
  • Reduce the size of Word files with FileMinimizerPhoto of Reduce the size of Word files with FileMinimizer
    reduce the size of word files with fileminimizer - to share large word data files, you want to reduce the size of word files to easily share via the internet. fileminimizer suite software will help you reduce the size of the word file in a short way

Office information