| |
|
Q) How do I resize columns in Excel?
A) To resize columns in Excel:
- Place your mouse over the line to the right side of the column heading until the cursor becomes a plus.
- Hold down the left button and drag the line to either side until the column is the width you want.
Tips:
- Fit the contents — To make the column width fit the contents, double-click the boundary to the right of the column heading. To do the same for all columns on the worksheet, click the Select All button and then double-click a boundary to the right of the one of the column headings.
- Change multiple columns — To change the column width for multiple columns, select the columns you want to change, and then drag a boundary to the right of a selected column heading. To change the column width for all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.
- Manually change the width — To manually change the width, select the column, point to Column on the Format menu, click Width, and then enter a number.
- Copy a width — To copy the width of one column to another, select the cell in the column with the width you want copied, click Copy on the Standard toolbar, and then select the column you want to copy the width information to. On the Edit menu, click Paste Special, and then click Column Widths.
|
|
|