How to Make Multiple Cells Bigger on Excel

Techwalla may earn compensation through affiliate links in this story.
Resize the cell borders on an Excel worksheet to fit the content.

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.

Advertisement

Adjust the Cell Borders

Step 1

Open the Excel worksheet.

Step 2

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 3

Click and drag the boundary line left or right to resize the column or row. Release the mouse button.

Advertisement

Add More Lines to Wrap Text

Step 1

Open the Excel worksheet.

Step 2

Click the "Home" tab on the command ribbon.

Step 3

Click and drag on the adjacent cells where you wish to add extra lines to the cells.

Step 4

Click the "Wrap Text" button in the "Alignment" group.

Advertisement

Step 5

Type in the selected cell. The text will wrap on multiple lines inside a taller cell. The cell does not widen.

Step 6

Click the row header. Drag the row's bottom border to display all the wrapped text in the resized cell.

Advertisement

references