Advice 1: As in Excel to do the numbering

When working with tables in Microsoft Office Excel the user may want to number the rows or columns. If the task to use special commands, this will help to save forces and time.
As in Excel to do the numbering
Instruction
1
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.
2
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.
3
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.
4
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.
5
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.
6
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: How to make a multilevel list

In order to format text as headings, paragraphs and subparagraphs, it is not necessary to use additional software. Enough to the existing text editor to launch automatically a team responsible for how to make a multilevel list.
How to make a multilevel list
You will need
  • The Command "List".
Instruction
1
Go to the text editor Microsoft Office Word. Open in the top menu bar section Format. Locate and click the "List". You will see new window, where you can specify the desired format for your list.
2
Click on the tab labeled "multi-level", so as to make multilevel list there automatically from examples. Select the option list with a certain structure levels. It can be the most different - from simple Arabic numbers to Roman numerals and embellished characters. Click "Ok".
3
If you need to change the structure of the multilevel list, then click the bottom button "Change". In the new window, the "Modify multilevel list" set for each level your number format, font, or symbols, and also set the position of the marker and text.
Note
In newer versions of word function "Multilevel list" has acquired a special separate button, which is located on the main panel, next to the numbered list and bullets.
Useful advice
In order to add a new level in the list, click "More." If you want to cancel in the list of changes click "Cancel".

Advice 3: 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.
As in Excel to number
You will need
  • The table editor Microsoft Office Excel version 2007 or 2010.
Instruction
1
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.
2
Enter the first and second numbers in the elementary cells are selected for numbering column or row. Then select both those cells.
3
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.
4
Release the mouse button and Excel will fill all the rooms allocated in this way cell.
5
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".
6
Set the direction of numbering by checking the box next to "by rows" or "columns".
7
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.
8
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.
9
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 4: How to Excel collapse rows

In Microsoft Office Excel, you can hide columns and rows in the table. This is useful in cases when it is necessary to increase the visibility complex tables, displaying only the most important data, or hide confidential information.
How to Excel collapse rows
Instruction
1
When you minimize linesdisappear and the corresponding headers, consequently, anyone opening the Excel workbook it will be easy to guess that if after line 3 is line 5, then line 4 is hidden. Keep this in mind, making the data on the sheet.
2
To roll of the line, move the cursor to the column name strings in the left part of the window. Click with the left mouse button on the line which will start a selection. Holding it down, move the cursor to the line where the selection ends. Release the mouse button.
3
If the rows are not adjacent, press Ctrl and while holding it, select with the mouse the desired line. In this mode, do not use the mouse wheel to move through the sheet, as the Ctrl key is responsible for the page zoom. Use the scroll bar. If you still want to move around the worksheet using the mouse, hold at the time of the scroll hot key.
4
Select the desired range, click the right mouse button on the selection. In the context menu select "Hide" by clicking on it with the left mouse button. The selected rows will be collapsed. To perform this task, you can use the buttons on the standard toolbar.
5
Highlight the rowsthat need to be undeployed and click the Home tab. On the toolbar find the "Cell". Click on the "Format". In the drop-down menu, select the group the "Visibility" and "Hide or display". Unfold the submenu. Choose "Hide line".
6
To return the display collapsed rows, select two adjacent rows, between which hidden data and click on the selection with the right mouse button. In the context menu select "Display". Another option: do not select rowsand cells that meet the specified conditions. On the toolbar in menu "Format" select the "Display string" from the group "Hide or show".

Advice 5: 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.
In Excel number of cells
Instruction
1
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.
2
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.
3
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.
Note
To number the cells in reverse order (highest to lowest), you need to meet the same conditions, but with a minus sign.
Useful advice
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.
Is the advice useful?
Search