How to change or adjust the column width in Excel 2007

1. To adjust the column width to fit the current text, move the mouse pointer to the right border of the column until it changes to a cross as shown and then double click on it.

2. To adjust the column width manually, move the mouse pointer to the right border of the column until it changes to a cross as shown, hold down the left mouse button then drag the mouse until you get the right width.

Before

After

3. To adjust the column width to give it fixed size:

1. In the Home tab , Cells group click Format then Column Width



2. The Column Width window will open.



3. Enter the required column width.

Notes:

1. The units shown are the number of characters in the default text format.

2. You can enter any number between 0 and 255.

3. If you enter 0 the column will be hidden.

Related posts:

1. How to apply a cell format to other cells
2. How to change tab color in Excel 2007
3. How to change page orientation in Excel 2007
4. How to change Excel default file location
5. How to create a custom cell style in Excel 2007