Instructions for numbering in Excel

Using Excel to enter and process data, make sure that with a lot of data you will need to number them. With short data, you can manually enter the order number for the data manually, but with long data lists this job will take a lot of time. So you can use the features that Excel supports for automatic numbering.

The article shows some ways of automatic numbering in Excel.

Method 1: Number with your mouse

Numbering with the mouse cursor has 2 ways: numbering for short lists and numbering for long lists.

1. Number the number with the mouse for the short list.

This method is used for short-numbered lists, you can quickly drag the mouse cursor.

Step 1: In the list to be numbered you enter the number you need to start numbering in the first box, for example, the number 1.

Instructions for numbering in Excel Picture 1

Step 2: Hold down CTRL and drag the mouse cursor to the lower right corner of the first cell you just entered the number until the mouse pointer turns into a + sign and there is a small + sign at the top as shown below.

Instructions for numbering in Excel Picture 2

Step 3: Hold down the left mouse button and drag the mouse pointer to the end of the numbered list.

Instructions for numbering in Excel Picture 3

Your results will be listed in ascending order:

Instructions for numbering in Excel Picture 4

2. Number the number with the mouse for the long list.

For lists that need to be numbered in the order of hundreds and thousands of lines, you should do the following:

Step 1: Enter the first ordinal number you want to start numbering in the example list starting from 1, followed by the second number in the next box, example 2 (if you want to number one by one) 1 unit increments then you enter the next number as 2, if you want to number the ascending 2 units then you enter the next number is 3 .).

Instructions for numbering in Excel Picture 5

Step 2: Drag the mouse to select the two cells you just entered and drag the mouse pointer into the lower right corner of the second cell so that the cursor appears + sign .

Instructions for numbering in Excel Picture 6

Step 3: Double-click the left mouse button to let Excel automatically number you. Your results will be as follows:

Instructions for numbering in Excel Picture 7

Method 2: Number the number with the formula

Step 1: Enter the first ordinal number to be numbered in the starting number box (any number).

Instructions for numbering in Excel Picture 8

Step 2: Enter the formula in the next cell eg = A5 + 1

Where: A5 is the first cell that you enter in step 1.

1 is a unit of increase, if you want to increase by 2 units then replace the number 1 with the number 2 .

Instructions for numbering in Excel Picture 9

Step 3: Then you drag the cursor in the lower right corner of the formula cell. When the mouse pointer changes to a + symbol, you drag the mouse down to copy the numbered formula in Excel.

Instructions for numbering in Excel Picture 10

Your results will be as follows:

Instructions for numbering in Excel Picture 11

Thus you quickly numbered automatically in Excel. Good luck!

5 ★ | 1 Vote

May be interested

  • Page numbering in Excel does not start from 1Page numbering in Excel does not start from 1
    excel does not split separate pages like in word, but when printed, they will need to be broken down into individual pages. and you can also number the page for excel like word, can optionally number the page from one or page numbering in excel does not start from 1.
  • How to Number Pages in CanvaHow to Number Pages in Canva
    page numbering in canva makes it easier for users to follow and shows professionalism when you create presentation slides in canva.
  • Page numbering steps in Microsoft Word MicrosoftPage numbering steps in Microsoft Word Microsoft
    page 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.
  • MS Excel 2003 - Lesson 3: Manipulating data in spreadsheetsMS Excel 2003 - Lesson 3: Manipulating data in spreadsheets
    the 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.
  • Page numbering in Word 2016Page numbering in Word 2016
    page numbering is an indispensable operation and very important for long text. the following article provides detailed instructions for page numbering in word 2016.
  • How to insert page numbers in ExcelHow to insert page numbers in Excel
    page 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 2007How to number pages in Word 2007
    page numbering on word is a basic operation and is often done, making the document more intuitive and scientific.
  • How to type pages in Word 2010How to type pages in Word 2010
    when numbering pages in word 2010, especially when making dissertation reports, references, guidelines will make the document easier to see and scientific.
  • Instructions for numbering pages from any page in Word quickly 2020Instructions for numbering pages from any page in Word quickly 2020
    instructions for page numbering from any page in word quickly 2020. if the word document has the first page is the table of contents .... that you only want to number the page from the beginning page with the document content, you need to do follow any of the page numbering instructions below.
  • Page numbering in PowerpointPage numbering in Powerpoint
    are 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.