How to Make Multiple Cells Bigger on Excel

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.

...
Resize the cell borders on an Excel worksheet to fit the content.

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.

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.