excel training course london - Column widths

Hi Sue

Thanks for your question.

There are two features you can use together to keep columns the same width, even once you start typing into a cell.

Firstly, select the columns you wish to make a uniform width, then go to Format-Column-Width.

You can then enter a width into the box (standard width is 8.43).

Secondly, turn on the Wrap Text feature before you start typing into the column (otherwise the column width will expand automatically).

You can do this by selecting the columns you have changed the width of then going to Format-Cells-Alignment and ticking the Wrap Text box down the bottom of the dialogue box and clicking OK.

Amanda