Microsoft Excel 2010 lets you control the size of a worksheet's cells. By default, the cells appear in uniform size. Resize one cell or multiple cells to fit all your data. For example, adjust the borders to allow more data to display in a wider cell. You can also apply an "Alignment" command so that the text wraps into a taller cell when there are multiple lines.
Adjust the Cell Borders
Step
Open the Excel worksheet.
Step
Move your cursor over the separator line between two headers — for example, the vertical line between column headers "B" and "C." The pointer changes to a small, black, vertical line with two opposing arrows. If this symbol does not appear, click the header and then hover the cursor over the separator line.
Video of the Day
Step
Click and drag the boundary line left or right to resize the column or row. Release the mouse button.
Add More Lines to Wrap Text
Step
Open the Excel worksheet.
Step
Click the "Home" tab on the command ribbon.
Step
Click and drag on the adjacent cells where you wish to add extra lines to the cells.
Step
Click the "Wrap Text" button in the "Alignment" group.
Step
Type in the selected cell. The text will wrap on multiple lines inside a taller cell. The cell does not widen.
Step
Click the row header. Drag the row's bottom border to display all the wrapped text in the resized cell.
