Excel Digest

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.