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 change the width of columns in Excel.
One thing to remember though - you can't just widen a single cell - you have to widen the entire row or column.
As with adding new rows, there is more than one way to change column widths in Excel.For this tutorial we will change column widths using options using the mouse.
For this tutorial:
Note: 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 with the left mouse button and drag the double - headed arrow to the right to widen column D until all of the data is visible - approximate width of 13 (123 pixels).
- Widen columns E, F, and G if needed to show all data .
Part 2 of this tutorial, which completes the formatting for the IF function worksheet, covers such topics as changing the alignment of data, merge and center titles, and shading alternate rows of data with conditional formatting.
Return to Index page