Ways to automatically numbering strings in Excel

Word and Excel developers have provided several simple techniques for rapidly and light automatic cell numbering, even in a very large table. Site Office.microsoft.com gives two main ways to numbering columns and rows in Excel - "Filling the cells by a sequence of numbers" and "Using the string function" for row numbering. There is another third method, progressive - this is the use of the "Fill" button

Method 1 Numbering of cells in Excel (easy and fast)
"Filling the cells by a sequence of numbers"

"Filling the cells by a sequence of numbers" is a very simple and convenient method of automatic numbering of cells in Excel. This method is ideal for small tables. The entire numbering process is reduced to the introduction in the first two cells of the initial numbers of a number of numbering and subsequently dragging the selection marker to the desired number of rows or columns.
In order to:

1. Enter the initial value for a number of filling numbers in the first cell.
2. Enter the subsequent value to the second cell for a number of filling numbers to set a fill sample. For example, if you need to specify a sequence of type 1, 2, 3, 4, 5 ..., you need to enter 1 and 2 in the first two cells. If a sequence of type 2, 4, 6, 8 is needed, you need to enter 2 and 4, etc.
3. Highlight both Cells in the discharge unit
4. Drag the selection marker in the desired direction, on the desired number of cells. This method works in any direction (up, down, left, right). Accordingly, the numbering will occur in an increasing or descending order.

Approx.
What is a selection marker and how to drag it
Isolation marker is the selection of a cell or a number of cells with the help of a rectangular area (cursor). To drag the selection marker, you need to bring the mouse cursor to the square in the lower right corner of the dedicated cell or range of cells. The mouse cursor changes with a white cross on black. It looks like this:

Dragging a selection marker in different directions can be made any numbering of cells for any table in Excel:

Approx.
Dragging the marker refers to the disadvantages of this numbering method, since in large tables this is a very laborious process.

Method 2 of the numbering of cells in Excel (very awake)
"Using a string function"

The method is more suitable for automatic numbering of column cells. In principle, everything is almost both in the first case, with the only difference that instead of introducing the first two numbers, to specify the sample of the number of numbering values, you need to enter the formula using the "string" function. For this, we put the cursor in the cell, in the formula string we enter \u003d String (A1) And we are taking our favorite marker down, on the desired number of cells.

Method 3 of the numbering of cells in Excel (progressively)
"Using the Progression Function"

The method is very good for large and very large tables when you carry the marker tedious.

In this case, nothing needs to drag. It will only be necessary to specify the initial number in the desired cell, call the "Progression" function and specify the fill direction (string or column), the fill step (how much to add a value) and the limit value for filling (the number of future numbered cells). At the bottom, the screenshots show the order of the buttons in the Excel window to achieve the desired result.

1. After filling the cells of progression, you can add the numbering of the cells with the usual drag of the marker (Method No. 1)
2. Types of progressions (arithmetic and geometric) are described in the algebra textbook for the ninth grade.

Method 4 of the numbering of cells in Excel (very fast and progressively)
"Fast use of the progression function"

By default, in Excel, the progression fill setting window is adjusted for the usual numbering order of cells. This can use for quick numbering rows or columns.

For quick numbering of the column cells of any size, we do this:

1. Introduce the required initial number of numbering in the first cell, for example "1", "101" or "19" (without quotes)
2. Select the first cell to the block with the initial digit ("1", "101" or "19"), and below the number of cells that need to be numbered.
3. The method specified above is the "Progression" window
4. Do not look at anything. Just click OK!
5. As a result, the numbering on the entire dedicated cell block and in the specified range.

How to quickly highlight the cells of the cells in Excel
Movement of the cursor with a squeezed left mouse button (LKM).

How to quickly highlight a large cell block in Excel
You need to put the cursor to the initial cell, enter the address-target number in the active cell window, press the SHIFT + ENTER key combination. The location of the active cell window is indicated in the screenshot. When you enter the address-number of the final cell, pay attention to the syntax (writing procedure).

Numbering Table cells in Word (cheap and angry)

Numbering table cells in Word is much easier. It is done using the button to create a numbered list. For this you need:

1. Select the desired cells in the block
2. Press the button to create a numbered list (1. 2. 3. ...)
3. As a result, we obtain a table with the cellular block (columns or lines, options), in which the numbering of the cells will be automatically executed when they are removed or addition.

Now, our block (column, string, table) works as a regular numbered list that automatically expands or decreases by the number of position positions (rows or cells). When adding or removing rows (cells) in such a table, their numbering will be performed automatically.

If you need to numbered the strings in the created and, possibly, the table in the MS Word program, the first thing that comes to mind is to do it manually. Of course, you can always add another column to the beginning of the table and use it for the numbering, entering the numbers in increasing order. That's just appropriate such a method is not always.

Adding a numbering of rows to a manual table can be a less suitable solution only when you are sure that the table will no longer change. Otherwise, when adding a string with or without data, the numbering in any case will also be changed. The only correct solution in this case is to make the row automatic numbering in the Word Table, which we will tell below.

1. Highlight the column in the table to be used for the numbering.

Note: If your table has a hat (string with a name / description of the contents of columns), the first cell is not necessary to allocate the first line.

2. In the tab "The main" in a group "Paragraph" Press the button "Numbering"intended for creating numbered lists in the text.

3. All cells in the column you have selected will be numbered.

If necessary, you can always change the numbering font, its type of writing. This is done in the same way as with ordinary text, and our lessons will help you with this.

In addition to changing the font, such as writing size and other parameters, you can also change the location of the number numbers in the cell, rejecting the indent or increasing it. To do this, follow these steps:

1. Click right-click in the cell with a digit and select "Change indents on the list":

2. In the window that opens, set the necessary parameters for indents and numbering position.

To change the style of the numbering, use the button menu "Numbering".

Now, if you add new lines in the table, new data contributes to it, the numbering will be changed automatically, thereby paying you from unnecessary trouble.

Here, in fact, all, now you know even more about working with tables in Word, including how to make automatic numbering of lines.

The Word application supports automatic counting of the number of rows in the document and the display of the corresponding numbers next to them. This is convenient when you need to refer to a specific document string, such as a script or contract.

By default, each string is numbered in Word documents (with the exception of rows in tables, conventional and end footnotes, text fields and footers). However, you can choose which of these numbers should be displayed. You can display the rows numbers for the entire document or part of it or display the numbers through a specific interval, for example, for each tenth line (10, 20, 30, etc.).

Adding string numbers

View).

Notes:

If the inscription is located in the text on the page, it is considered one row. If the text on the page is the inscription, each string of the text is taken into account. At the same time, the lines of text inside the inscription are not taken into account.

Adding strings numbers in all document

Adding strings numbers in one or several sections

Deleting row numbers

You can delete rows numbers from the entire document, partition or paragraph.

Adding string numbers

Row numbers can be added for the entire document or part of it. They can only be viewed in the page markup mode (mode is indicated on the tab View).

Notes:

The table is considered one line.

The drawing is considered one line.

In the Microsoft Word text editor, you can create documents of various content - they can simply have text, tables, graphs, charts, a list of something and so on. And in some cases, it may be necessary to calculate strings with text or numb each new in the table.

In the Word, it is possible to do this and manually - just at the beginning of each Single the sequence number. Similarly, with a table - create a separate column on the left and slight rooms. But if the text will be made to the text, or add or delete the lines, then the numbering will be broken, and it will have to correct everything.

Therefore, in such cases, it is better to make automatic numbering for them, and this is done for both ordinary rows with text on the sheet and for the table. Let's deal with more detail with the numbering of strings in this article.

How to numbered strings

For example, I will take this text.

First, open the tab "Page layout" And in the group, click on the small arrow on the "Row numbers" button.

From the drop-down list, select one of the options.

It is possible to numbered them in the document "continuously" - the numbers will be affixed from the beginning to the end of the document in each row. If the text there are separation breaks, then it will continue to the first installed break.

"On each page" - The value on each new page will begin with a unit.

"In each section" - It is convenient to use if the text is divided into sections. In this case, they will be counted only in the section where you installed the cursor. Going to the next section and selecting this item, it will begin again - from the unit.

I chose a "continuous" numbering, and on the first installed division of the section it broke off. To continue to continue to put the cursor in the next paragraph with the text. And then from the drop-down list you can choose or "continuously" - so that the numbers continued, or "In each section" - To start numbers from the unit.

If you need to leave a paragraph without numbering, it can simply be an empty lines, or a whole paragraph with text, then put the cursor and click "Row numbers" - "To prohibit in the current paragraph". The numbering in it will be removed and continue further in the next paragraph.

In the drop-down list "Row numbers" also have an item.

By clicking on it, the window opens on the tab "Source of Paper". Here click on the button "Line numbering".

A small window will open. In it, you can set the initial value, at what distance it will be from the text and the number of numbers. After that, click "OK" in this window and in the window.

In the example, "Step" is selected - "2" and "from text" - "0.2 cm".

Automatically numbered strings in the table

To do this, you must first create a separate column, which will be used to push numbers. Then select it and on the Home tab in the "Paragraph" group, click on the arrow on the "Numbering" button.

Please note that in one cell there may be several lines. After the arrangement of the numbering, they will be considered one. Therefore, if you need to numbered each row with the Tectoral, in the "No." column, divide the corresponding cell on as much as you have in it rows of text. Then you can remove the boundaries in the table in the Word for this cell, but at the same time the numbers will remain.

Choose a suitable view of the room from the listing list. If nothing is suitable, click on the item "Determine the new number format" And choose the style yourself.

Read more about how to numbered, it is possible in the articles of lists in Word.

If thus numbered the strings, then even after you insert a new one or remove the unnecessary, nothing will break.

To change the value to continue the numbers, select the desired and in the corresponding drop-down list, select "Set initial meaning".

In the next window, put a marker in the "Start New List" field and select the number for it with which it will start. Click OK.

If you want to continue the previous list, but it is necessary to change the initial value, please note that you need to choose a number that the previous list ends.

In the example, I started a new list from the unit.

I hope now you will have to numbered the rows in the Word Document, both for text, and make the automatic numbering of rows in the table.

Quite often, users ask a question how to make rows numbering in Excel? It is it that we will consider in this article.

In Excel, there are several ways to help you quickly arrange numbers. With the help of the program you can do everything automatically, or arrange numbers yourself. Even despite the name of the second way, both of them will greatly facilitate your work with the tables: you will not need to enter numbers in order in each row separately.

Manually

To begin with, make a manual numbering of strings. To do this, highlight the cell, which must be the first and write in it "1", in the cell below write "2". We allocate them with the mouse. Now move the cursor to the right lower corner of the selected blocks - the auto-complete marker appears in the form of a black plus game. Hold the left mouse button and pull it down on the required amount. Thus, we numbered the rows using a simple sequence of numbers.

Automatically

It can be made in various ways.

Use of progression

We highlight the desired cell on the sheet and put the number in it with which the account will begin, for example, "1". On the Home tab, click on the "Fill" button, and select "Progression" from the list.

In the next dialog box, we put a marker in the "Column" field, choose the necessary "step" and "Limit value". Then click "OK".

If in the "Step" field to put "2", then in the cells in order will be arranged: 1, 3, 5, 7. This can be useful when the table needs to numbered only odd or even numbers. In the second case, initially check the "2" tissue and select "Step" - "2", then it turns out: 2, 4, 6, 8.

As a result, the necessary rows or columns will be numbered.

Using a function

Select the desired block and write the following: \u003d Row (B3), where B3 is the address of the current cell.

Now hover the cursor to the right lower corner of the block, it will take the form of a black plus. Then press the left mouse button and stretch down to make automatic numbering.

If the unit with which the numbering should begin, for the "string" function as an argument, specify the current address - B3, or leave the brackets empty - "line ()", then the function will return the number of the row to the cell into which it is entered. In the example, the number number "3", so the account begins with three.

In order for the numbering of strings in Excel starts from a unit, count the number of rows that are above you need. In the example of their two. Then select the desired cell and write the function: \u003d row () - 2. Here "-2" is the quantity that you counted.

Now in block B3 costs "1". Through the numbering down how much is needed.

This method is also convenient because it is fully automated. If you need to add or delete a string from the Excel sheet, the account in the table does not assemble.

For example, we remove the fifth row of the sheet, in the table it is numbered as "3". The text "VVVV" was removed, and the rest of the rest rose to one row above. At the same time, the account of the rows in the table did not break.

Now, you will definitely numbered in the desired order of the string in Excel. To do this, it is simply necessary to use manual or automatic ways that are described in the article.

Rate article: