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

  • Instructions to make a beautiful background for PowerPoint slidesPhoto of Instructions to make a beautiful background for PowerPoint slides
    introducing to you how to create beautiful backgrounds for power point presentation slides 2013.
  • Set up the working environment in WordPhoto of Set up the working environment in Word
    just one set of parameters that apply to your entire word document will save you a lot of time. i will introduce you to set some key parameters important in the drafting process.
  • Instructions on how to graph in ExcelPhoto of Instructions on how to graph in Excel
    instructions on how to graph in excel. excel helps you to process and calculate data effectively, excel supports you to graph quickly.
  • Insert audio into Word documentsPhoto of Insert audio into Word documents
    if you want your presentation to be more lively, to attract readers or you want to make specific sound proofs, you can add sound to your text, if you do not know how to follow, follow the article. down here.
  • How to insert images into Word documentsPhoto of How to insert images into Word documents
    text will be difficult to read and boring if the whole word is text, lack of illustrations and reduce the effect of conveying the content of the text. so today i introduce to you how to insert images into text and edit photos after inserting.
  • Create borders and fill the background for text in WordPhoto of Create borders and fill the background for text in Word
    the first impression of the readers with the book is the cover so the beautiful cover presentation is a very important part when writing documents. this article i will guide you how to create borders and fill the background for text.