You may have one column in a table that contains a description that is quite long. If your text is several sentences, it would be impractical to make your column wide enough to include the longest value in your column. Did you know that Excel offers you the capability to wrap text on a cell-by-cell basis to resolve this issue?
When you wrap text, one feature of Excel jumps out at you. All cells in Excel are initially set to have their cell contents aligned with the bottom of the cell. You may not notice this because most cells in Excel are the same height. But when you wrap your text, the cell heights double or triple sometimes. When this happens, it becomes evident that the bottom alignment looks a little strange.
Follow the steps below to correct the problem:
- Decide on a reasonable column width for the column that contains your descriptive text.
- On your Home tab in the Cells group, select Format | Column Width.
- Select a width of 24 or greater.
- Choose the cells in the column to be wrapped.
- On your Home tab in the Alignment group, select Wrap text.
- Select all cells in your table.
- On your Home tab, in the Alignment group, select Alignment | Top Align.
The values in the other columns will now align with the top of your descriptive text.