Changing the column width of a table created in Excel, which is part of the Microsoft Office suite, is one of the most commonly used document editing procedures. As such, it is a standard feature of the program and does not require the use of additional third-party software. This operation can be performed both with the use of the mouse and with the use of several menu items of the service toolbar.
Instructions
Step 1
Click "Start" to bring up the main menu of the operating system. Go to the "All Programs" item.
Step 2
Expand Microsoft Office and start Excel.
Step 3
Open the table to be edited. To change the display options for a single column, drag the right border of the desired column header to the desired width.
Step 4
Select multiple columns to be resized. Drag the right header line of either one to the position you want. To edit the entire table, use the Select All option and drag the border line of an arbitrary column to the desired width.
Step 5
Double click on the right border line of the selected column to enter the required value. To change the parameters of all columns, use the "Select All" option of the edited table again.
Step 6
Select the column to be modified according to the specified width and open the Format menu in the top toolbar of the Excel window.
Step 7
Select Column and choose Width.
Step 8
Select an arbitrary cell in the column selected as a sample width and copy it by clicking the "Copy" button in the toolbar of the office application window.
Step 9
Select the column to be resized to apply the pattern. To edit the selected parameter to match another column, expand the Edit menu in the top pane and select Paste Special. Use the Column Width option.
Step 10
Call the context menu of any sheet by clicking the right mouse button and select the "Select all sheets" item to change the default table column width parameter.
Step 11
Expand the Format menu and choose the Column command.
Step 12
Specify the item "Standard width" and enter the desired value in the corresponding field.
