On the Home tab, in the Clipboard group, click the Copy button or press CTRL+C.Ĭlick the cell in the column that is to be resized, and then click the Paste Special button in the Clipboard group.
Select the column whose width you want to copy.
To match one column’s width to another column, do the following.
Double-click the right boundary of the selected column.
On the Home tab in the Cells group, click the Format button and select the AutoFit Column Width item from the drop-down list. To change the column width to automatically fit the contents, select the column and do one of the following. Type the required width value in the invoked Column Width dialog. To set the column width to a specific value, select the column whose width you wish to change, and on the Home tab, in the Cells group, click Format | Column Width. To set the width of multiple columns, select these columns, and then drag the right boundary of one of the selected columns.
Drag the right boundary of the column header to resize a column’s width.
To change the column width, do one of the following. If you set the column width to 0, the column will be hidden. The default column width is 8.43 characters. In the Spreadsheet, the column width can vary from 0 to 255 characters of the default font specified by the predefined Normal style. Specify Column Width and Row Height Setting the column width