Change Column Widths in Excel
There are times when your data doesn't fit into a cell. The data is either too wide or far too narrow making the worksheet look unbalanced. When this happens it's easy to correct by changing column widths.
One thing to remember though - you can't change the width a single cell - you have to widen the entire column.
As with many of Excel's features, there are several ways to change column widths in Excel.For this tutorial we will change column widths using the mouse.
For help on these steps, refer to the image above.
- Place the mouse pointer on the line between columns D and E in the column header.
- The pointer will change to a double - headed arrow.
- Click and hold down the left mouse button and drag the double - headed arrow to the right to widen column D until all of the column title Total Income is visible - approximate width of 11 characters (106 pixels).
- Repeat the above steps to change the widths of columns A, B, C, E, and F as needed to show all data.