How to fill a column in Excel with ordinal numbers. Sequential number of rows in order after filter in Excel. Numbering lines with the string function

You can number columns, rows and pages in Excel. In Excel, they usually try to number lists, and sometimes they make very large lists that are then printed out and in order not to get confused in these printed sheets, it is necessary to pre-number the pages. In Excel, you can number rows and columns in several ways.

How to number rows and columns in Excel

• This method is used when you need to put numbering in Excel for several rows or columns. With this method, line numbering in Excel is carried out by filling in each cell by simply entering numbers into each cell.
• This method is used to put a number in order in Excel for a large number of rows and columns. With this method, you need to manually put the number in the Excel for the first cell. How to put numbering in Excel using the mouse and keyboard

  Then move the cursor over this first cell and press the left mouse button. The cursor must be moved to the lower right corner of this cell so that the cursor becomes a black cross. Press the Ctrl key on the keyboard and without releasing it press the left mouse button. Now, without releasing the mouse button and a key on the keyboard, you need to move the cursor over the column or along the line and thus you can number all the cells in Excel. To finally set the numbering in the Excel, you must first release the mouse button, and then the key on the keyboard.

• If you do not want to use the keyboard, then you will need to enter the row or column number in the first three cells manually in Excel by writing down the numbers 1, 2, 3 respectively. Then these three cells are selected, move the cursor over the cell with the number 1 and press the left mouse button ...
  In Excel, line numbering is done with the mouse

  Without releasing the mouse button, move the cursor to the number 3 and release the left mouse button. When all three cells are selected, you need to move the cursor in the form of a white cross to the lower right corner of the cell with the number 3 so that the cursor becomes a black cross. Press the left mouse button and, without releasing it, move the cursor along the column or line and you will automatically display the numbering in Excel of this cell to the right of the cursor. Having thus selected the required number of cells in a column or row, release the left mouse button and you will have a serial number in Excel in all selected cells.

• You can make the numbering in Excel automatically if there is a column filled with some data nearby or you need to number a column in the table. This automatic numbering in Excel in order only works with columns. To do this, you will need to manually fill in the row number for the first three cells in Excel by writing the numbers 1, 2, 3 respectively. Then these three cells are selected, move the cursor over the cell with the number 1 and press the left mouse button. Without releasing the mouse button, move the cursor to the number 3 and release the left mouse button.
  Automatic numbering in Excel is done by double clicking on the black square

  When all three cells are selected, you need to place the cursor in the form of a white cross on the black small square that is located in the lower right corner of the cell with the number 3, and the cursor should become in the form of a black cross. Now, to automatically number the Excel-tree, you need to quickly press the right mouse button twice and the column will be automatically numbered immediately to the end of the list or to the end of the table.

How to number pages in Excel

Sometimes you have to compose some huge lists, for example 10,000 lines. When you print these lists, you get many sheets, so you need to pre-number the pages in the Excel so as not to get confused in them later. First, these lists in Excel need to be divided into pages, to do this, go to the Insert tab and click Headers and Footers.

In Excel, page ordering is done through headers and footers

After that, the entire list will be divided into pages. Now you will need to put in the Excel number in order on these pages. Page numbering in Excel is done on the Design tab. By default, the page numbering in Excel will be located above the list in the list in the center. Excel page numbers can be positioned to the left, right, or center just below or above text. In order for the page number in Excel to be at the bottom of the list, you need to click on Go to footer in the toolbar. To indicate on which side for pages to put the serial number in Excel, you just need to move the cursor to the left, right or central part and press the left mouse button.

Page numbering in Excel is placed under the text or under the text

Now you will need to click on the Page number and then the code will be displayed in the selected place. After that, if you click on any cell in the list, then you will immediately see that all pages will be numbered.

Video

This video shows how you can number pages using headers and footers in Excel.

Today we will talk about fast numbering of table rows in order. The considered numbering methods will allow us in the future to save time and avoid the time-consuming process of numbering by manually setting the serial number in each cell. We will work in Excel 2010.

Let's get started.

Our task is to number the rows in order in this table:

Our first step will be to create an additional column, which will contain the ordinal numbers of the fruits listed in the table. We need to insert this column before column "A":

To this end, hover the cursor over the column heading "A", that is, the header cell of the Excel sheet "A" and right-click. A list of options will appear before our eyes, in which we will select the "Insert" option:

The Excel sheet and our table have been supplemented with the column we need. Now this new column has become column "A", and the column with the names of fruits has a heading "B". The column of fruit varieties from “B” was renamed to “C”, and the column with the number of kilograms in stock from “C” was changed to column “D”:

Our next step is to finish drawing the table. That is, we need to stroke each cell, newly created for the column ordinal numbers. In other words, define new table boundaries. To define the new borders of the table (outlining the cells), we first need to select the desired area. This can be done in two ways:

1. Select only the required cells in the column "A"

2. Select the entire table completely

Let's consider the first way. Select the cell "A1" by clicking the left mouse button:

Then, by pressing and holding the left mouse button, drag the selection down to the bottom border of the table, that is, to cell "A9" inclusive:

Now let go of the left mouse button and go to the top menu. Where, in the "Home" tab of the "Font" section, expand the content of the "Borders" option and select the "All Borders" option:

And here's what we got:

Consider the second selection method, that is, the selection of the entire table.

Select cell "A1" again and by pressing and holding the left mouse button drag the selection first to the right up to cell "D1" inclusive:

and then, without releasing the mouse button, down to the end of the table:

And again turn to the already familiar "Borders" option and select the "All Borders" option:

We see that the result is the same - all table cells in column "A" are circled.

I edited the entered heading, making the font bold, and placed it in the center of the cell. Now let's move on to the cell numbering itself.

By clicking the left mouse button, select the cell "A2" and enter the number "1":

In order for the program to perceive a certain sequence, and our sequence is the numbering of cells in order, we need to fill in one more cell. This cell will be cell "A3". Select this cell by clicking the mouse and enter the number "2":

Our next step is to select two numbered cells "A2" and "A3". Let's make this very selection:

and then move the mouse cursor over the point in the lower right corner of cell "A3" containing the serial number "2":

and double-click with the left mouse button:

As we can see, all subsequent cells received their serial numbers. Cell "A9" did not receive a sequential number, since I counted the total using the automatic summation option. Quite often, summary rows in tables are not numbered. But if we need to assign a serial number to the final row, then it is not at all necessary to enter the number in the cell manually.

Let's hover the mouse cursor over the dot in the lower right corner of cell "A8":

and then press the left mouse button and, keeping it pressed, drag the resulting selection down into cell "A9":

As soon as the selection captures cell "A9" release the mouse button. So we got the serial number for this cell:

We can use this method of numbering initially.

Let's go back to the moment when we numbered only the first two cells in column "A". Select them, and then grab the already known corner point with the mouse and drag the resulting selection down to the desired cell inclusive. In our example, this is cell "A9":

After we release the left mouse button, the serial numbers will take their place in the cells:

This way of numbering is convenient in cases where we supplement the table with lines:

Select the last two numbered cells ("A8" and "A9"), and then drag the selection down:

Releasing the mouse button, we will see the sequential numbering of additional cells:

If the numbering of the final line is not needed, then simply delete it. Select cell "A9" (in our example, line "9" contains the total) and press the "Delete" key. In those cases when we add rows not at the end of an already formed table, but somewhere in the middle, and must assign them serial numbers, then this numbering method will come to our aid here too. Let's consider this case.

It goes without saying that you need to change the numbering in order. Let's do it. Let's select two cells - "A3" and "A4":

Now let's repeat the already familiar steps. Grab the corner point with the mouse and drag the selected area down to cell "A20" with the serial number "16":

After releasing the left mouse button, we will see the updated numbering:

If the numbering of the final line is not needed, then delete it in a known way (press the "Delete" key).

It may well be that we want the numbering of lines (cells) after the final line to start with the ordinal number "11", and not with the number "12":

Let's make what we want. Select cell "A13" and replace the number 12 with the number 11, and in the cell "A14" we will replace the number 13 with the number 12. Then select both of these cells:

Now, hover over the corner point:

And by double-clicking the left mouse button, change the ordinal numbers of the following lines:

Microsoft Excel does not have the usual numbering of table rows that a Word user is used to. Therefore, in order to assign its own number to each name, the user will have to do this using one of the following actions:

• stretching;
• using a function;
• using a progression;
• using a special formula.

Stretching

The first method used by many novice users of the program is string stretching. To get the result in the form of automatically numbered lines, the user needs to do the following:

If the user needs to number the rows in the Excel table not through one, but through an interval of several numbers, then you need to do the following:

Thus, you can install any required interval changing numbers.

If a person needs an indent after a few cells, then this can be done like this:

By changing numbers and intervals, you can achieve almost any numbering of rows in Excel.

In this way, you can continue numbering from any digit, for example, by writing 22 and 23, the sequence will start from 22.

Merged cells can be numbered in the same way.

Function

This way of creating a number sequence is more automated. There is no need to pinch, select and drag anything, it is executed in this way:

There is another method for creating a list in Excel - using a progression.

Progression

This method is suitable for those who usually create large tables in Excel from Microsoft. This method can be used by accountants and other office workers, who often create voluminous tables.

You can insert cell numbering using the progression method as follows:

Formula

The last numbering method in Excel is the formula. Of all the above, this method is the most inconvenient. In order to use the formula, the user needs.

Until August http://thisav.fun/ thisav.com The shutdown might last two weeks and approach the Oct. 17date Lew mentioned, "then the whole thing ratchets up inintensity," said David Kotok, chairman and chief investmentofficer at Cumberland Advisors in Sarasota, Florida.

Three years http://efukt.fun/ efukt porn Her recent role as the family breadwinner was not lost on ГвЂВњRHONJâ†viewers, who↙ ve watched Joe Giudice struggle over four seasons since 2009 to keep his failing business ventures afloat while his wife suddenly developed a Midas touch.

Grace wrote
in article

Could I ask who "s calling? Http://silverdaddies.fun/ silver daddies If I can" t make a phone, text, credit card transaction without the Federal Government tracking it (and me by cell phone GPS records) and using that information to profile me then that is taking away my freedom.

Malcom wrote
in article

Another service? http://lamalinks.fun/ lamalink Start with the flatbreads. If you don’t have the time then buy some good-quality tortilla or pitta. Mix half the water with the flour, salt and oil and let it sit for 10 minutes. Slowly add more water, kneading the dough until you have an elastic, tacky dough that becomes smooth when rested. Cover with a damp cloth and rest for 30 minutes.

Stephanie wrote
in article

How many weeks "holiday a year are there? Http://rulertube.fun/ rulertube.com Richards is coming off a demoralizing lockout-shortened 2012-13 season. In the playoffs, Tortorella ГўВ" Richards "coach with the 2004 Stanley Cup champion Tampa Bay Lightning who was integral in attracting Richards to New York ↓demoted the veteran center to the fourth line toward the end of the first-round and then scratched Richards for the final two games of the Rangers" second-round loss to the Boston Bruins.

Dusty wrote
in article

Who would I report to? http://lamalinks.fun/ lama nudes NFLPA executive director DeMaurice Smith issued this statement to FOX Sports on Wednesday: "What does neutral arbitration add but more credibility? The majority of the policy that they already agreed to allows the Commissioner to impose discipline but an appeal is subject to neutral arbitration if the player so chooses. The players don "t want an exception to the rule."

How do you know each other? http://12yo.icu/ 12yo Still, the changes don "t address questions Facebook has faced over the amount of data it collects about teens on its site. Privacy groups recently sent a letter to the Federal Trade Commission asking the agency to evaluate Facebook's policies on this issue, and have the network create separate policies for teens on the issue of data collection.

Fidel wrote
in article

I "d like to cancel a check http://keezmovies.in.net/ keez movie But the young Republican said she wanted to be careful not to make the show political or one that" lectures or preaches "to young people - rather, she wants it to open discussions she said she grew up hearing on television.

Anibal wrote
in article

Could you transfer $ 1000 from my current account to my deposit account? http://9taxi.in.net/ www.9taxi.com Otherwise, it warned, the Help to Buy program "risks recreating the perverse incentives that led to the 2000s-era US housing bubble" "and subsequent subprime mortgage crisis, a major factor in the worldwide financial crash of recent years.

The National Gallery http://xnxx-xnxx.space/ indian xnxx A person with direct knowledge said Summers had been an adviser to Nasdaq for "a number of years," but would not be more specific. The person asked to remain anonymous because of the sensitivity of the matter.

Excel is one of the most adapted programs for maintaining various tables. It is actively used for data accounting, statistics, has graphical tools. Also, to facilitate the use of the program, there are many options to help speed up the work in Excel. One of them is automatic line numbering.

Of course, everything can be done manually. But, when there is a considerable amount of work to be done, then it is simply impermissible to waste time on actions that can be performed in a matter of minutes. So, there are many methods to numbering in Excel.

Numbering methods

1 Method. It's pretty simple. Using it, it is possible to automatically number rows or columns.

• First, we write the number into the cell where the numbering will start, we take one for clarity. This cell will appear in a black frame. Also below, in its right corner, a small black square appears.
• You need to hover over it, click with the left mouse button. Press Ctrl at the same time. Keeping them in this position, you need to drag the cursor to the point where the numbering should end.
• The entire field selected in this way will become numbered in order. You can also do everything without the keyboard. Then the cells will be filled with the same element. We have recorded one as an example. This number will be repeated in every cell in the selection area.

2 Method. Similarly simple and straightforward. But, the difference is that the keyboard is not used, only a mouse is needed.

• In the cell where the numbering begins, you must enter the first digit. Let's start at one again.
• In the next cell, you need to indicate the number that will follow the unit. For example, if this is a normal numbering, then 1 is followed by 2. In this case, the numbering will continue with the numbers 1, 2, 3, etc. If you want the numbers to follow in a different sequence (6, 8, 10 ...), then the first cells must be filled in 6 and 8. Thanks to this, a step was set, with which the numbers will be set in automatic mode.
• Now you just need to select the first two cells with numbers. There is a small black square in the lower right corner. It is necessary to click on it with the mouse (left button). And, keeping it pressed, drag the cursor to the cell where the numbering ends.
• The entire selected area will be filled with numbers in the selected order. If it becomes necessary to continue the already finished numbering (for example, to supplement the list of products), then this method is perfect. It is enough just to select the last 2 cells and increase the list by the required number of lines.

3 Method. Using the formula.

• It is necessary to select the cell from which the numbering will begin. In it, write the formula: \u003d A3 + 1. This formula uses the value of the previous cell. For example, the specified formula "A3 + 1" must be written in cell A4. It is not necessary to add 1, it all depends on the step that you need to set for numbering. If each subsequent number will increase by one, then "+1", if by two, then "+2".
• After filling out the formula, press Enter. And the desired number will appear in the cell.
• Next, you need to select the cell with the formula. And by clicking the black square in the lower right corner, drag the cursor until the end of the numbering.

4 Method. It is convenient in that you can initially set all the indicators: the number of lines, the numbering step and the type of progression.

• Start as in the first two methods. You need to enter 1 in the first cell.
• Next, select the cell with the number. Then go to the menu under the heading "Home". There select "Editing".
• Click "fill". Next, in the drop-down menu, select "progression".
• A window will open in which you need to set the desired parameters. Here you can choose column or row numbering. Choose the type of progression and its step. And in the “limit value” heading, you must specify the number of rows or columns that will be numbered.
• The last step is to click "OK". Then the program does everything.
• As a result of these actions, a ready-made, numbered row (or column) is obtained.

5 Method. Very similar to the previous one, but allows you to skip filling the table. Suitable when it is necessary that the numbers follow one after another, in the usual order.

• We write one in the cell.
• Now we need to select it. And by clicking on the black square at the bottom right, drag the mouse to the desired cell until the entire area where numbering is required becomes selected.
• You don't need to do anything with this field, let it remain selected for now. This is followed by the heading "editing", as in the paragraph above. There select "fill" and "Progression".
• A window for progression will open. There is no need to make any settings here. Just press ok. Then, the entire highlighted field will be numbered in the correct sequence.

Video

Conclusion

Obviously, there are a lot of methods. Moreover, all of them are quite simple and understandable in action. Even a beginner will be able to find a convenient option for himself.