Width of columns in documents of the tabular editor of Microsoft Office of Excel determines convenience of use by them and appearance. This parameter at a conclusion of tables to the press is especially important. Several ways of a setting width of columns are provided in Excel: introduction of numbers, dragging of borders. And it is possible to entrust selection of parameter to the program.
It is required to you
- Tabular editor of Microsoft Office of Excel.
Instruction
1. For installation of the identical fixed width of group of columns of the table begin with their allocation. Click with a mouse heading of one of columns, then press the Shift key and by means of an arrow to the left or to the right extend allocation other necessary columns.
2. Choose one of ways of installation of width for group of the allocated columns. It can be done, having specified exact numerical value, or to pick up the necessary size visually. To use the first option, click the allocated range of columns with the right mouse button and in a context menu choose the line "Column Width". Enter numerical value and press the OK button. The sizes of cells in Excel are by default set in units called "points" (points). Each of them is equal 1/72 parts of inch or 1/28 share of centimeter.
3. The second — visual — option is implemented by means of a mouse. Guide its index at border between headings of any two columns. When the cursor changes a look and will become a bidirectional horizontal arrow, press the left button and move apart or shift border up to the necessary width.
4. If it is necessary to establish width corresponding to width of the data placed in it for each column, allocate all cells of a leaf. Click an empty cage on a joint of headings of lines and columns. Then open a drop-down list the "Format" placed in group of the Cells teams on the Main tab. Choose the line "Automatic Selection of Width of a Column". It is possible to make it not only the mouse pointer, but also from the keyboard: press the key to pass to this line of the list, and then the Enter key for its activation.
5. Except width of the columns Excel allows to set also width of area of the press, i.e. to establish horizontal borders of the table fragment brought to the printer. To use this option, allocate the necessary range of columns, and then go to the Page Marking tab. In group of the teams "Page setup" open a drop-down list "Area of the press" and select the Set item.