An independent input serial number in each cell is a long process, much easier to use AutoFill. The fill handle (the frame with a small square in the lower right corner) is displayed in the program by default. If for some reason in your version it is not, turn it on.
To do this click on the Office button in the upper left corner of the window and select the menu "Excel Options". This will open a new dialog box. Navigate to it in the "Advanced" section. In the "edit Options" select the check box for "Enable fill handles and drag-and-drop cells". Apply the new settings by pressing the OK button in the lower right corner of the window.
Keep in the first cell of the first serial number in the next cell, the second sequence number. Select filled cells and move the mouse cursor to the small square in the right corner of the frame. Press the left mouse button and holding it drag the frame in the desired direction. Empty cells are automatically marked with the missing sequence numbers.
The option of using context menu, autocomplete: enter the first cell of the first sequence number, drag the frame in the desired direction for the desired number of cells. Release the left mouse button near the marker icon will appear in the minimized menu the "autocomplete Settings", click on it with the left mouse button and set the marker next to "Fill" in empty cells will be prescribed rooms.
For numbering you can use a simple formula. Enter in the first cell of the first sequence number, move the cursor to the second cell and type in the formula bar an equal sign. Click the left mouse button in the first cell, then enter without quotes "+1" and press Enter. Select the cell with the formula and drag its outline to the desired number of cells. In the end you'll have a formula for the second cell: =A1+1, for the third cell: =A2+1, for fourth: =A3+1.
If you use a multilevel list for example, 1.1, 1.2, 1.3 and so on, set the cells to text format so that the program does not change the sequence number to the name of the month. To do this, click on the cell (range of cells), right-click and select the menu item "Format cells". In the opened dialog box, select the desired format in the tab "Number".
Advice 2 : As in Excel to number
In the table editor Microsoft Office Excel has line numbers - these numbers can be seen to the left of the table. However, these numbers are used to denote the coordinates of the cells and on the print. In addition, the beginning of the user-created tables are not always placed in the first cell of the column. To eliminate such inconveniences in the table have to add a separate column or row and fill it with rooms. To do it manually in Excel is not required.
You will need
- The table editor Microsoft Office Excel version 2007 or 2010.
If you number have data in an existing table, the structure of which is not provided for this column, it will have to add. To do this, select the column before which should stand rooms by clicking its title. Then click selection, right-click and select the context menu command "Paste". If the numbers should be placed horizontally, select the row and using the context menu add a blank line.
Enter the first and second numbers in the elementary cells are selected for numbering column or row. Then select both those cells.
Move the mouse pointer to the bottom right corner of the selection - it needs to change, ridged, plus become plus black and flat. When this happens, press the left mouse button and drag the border of the selection to the last cell of the enumeration.
Release the mouse button and Excel will fill all the rooms allocated in this way cell.
The described method is useful when number need a relatively small number of rows or columns, and for the remaining cases, it is better to use another variant of this operation. Start with entering the number in the first cell on created row or column, and then select it and open the drop-down list on the Fill. On the Home tab in the menu of the table editor, it is placed in the command group Edit. Select the command "Progression".
Set the direction of numbering by checking the box next to "by rows" or "columns".
In section Type, select method of filling cells with numbers. The usual numbering corresponds to the item "arithmetic", but here you can set and the numbers increase exponentially, and you can set several variants of calendar dates.
For the usual numbering, leave the field "Step" value by default (unit), and if the numbers should increase with another increment, type the desired value.
In the field "Limit value" enter the number of the last cell which should be numbered. After that, click OK, and Excel will fill the column or row numbers in accordance with the specified parameters.
Advice 3 : In Excel number of cells
Renumber the cells in the program Excel in several ways, depending on the expected result. The numbers can go in order of numbers in a geometric or arithmetic progression, we can number the cells in one and an increase of as many units as you need.
To number the cells sequentially in format "1, 2, 3, 4... n", select the first cell of the table and enter the first digit, which will start the countdown. Then put the mouse cursor in the lower right corner cells (corner cells should appear black cross) and press the Ctrl key. While holding down, press the left mouse button, and drag down or right as many cells as you need. Release the mouse button and then the Ctrl button on the keyboard.
If you need to number the cell with the period in the format "1, 3, 5, 7... n", put in the first cell of the table the initial number. Then select the range of cells which should be numbered. In the main program menu select "edit" / "Fill" / "Progression". In the window that appears, in the "Location" button indicating the selection will be set automatically (either by columns or by rows). In the "Type" select the type of numbering of cells (e.g. arithmetic). In the "Step" set a period, which should be numbered (e.g. 2). If necessary, check limit value for the cells in which the numbering will happen to a certain number. Click OK.
In Excel, you can enumerate cells in an arbitrary format, i.e. to number, skipping a few of them and with a difference of a few units (for example: every second, different from the previous five). To do this, select the first cell number from which the countdown will start. Then through the desired number of cells in the desired cell after write the following formula: put an equals sign, then click in the first cell with the number to dial on the keypad "+" and put the number you want to increase the number of cells following the first. Press Enter. Then select the range that includes the cell, the first and the second resulting from the application of the formula, figure. Put the mouse cursor in the lower right corner to display a black cross, press the right button of the mouse and slide it to the length of the row of numbers you want to receive. To formula to convert to numbers, highlight the number and press the right mouse button. Select the context menu "Copy" command. Around the selected range will appear dotted snake. Again click the right mouse button and go to the menu command "paste Special". In the opened window click the button next to the word "Value". Click OK.
To number the cells in reverse order (highest to lowest), you need to meet the same conditions, but with a minus sign.
For a more clear and correct numbering of cells is better to use the formula. They prescribe you the same amount of units, which increases or decreases the new number.