How to expand cells to fit text in Excel

January 5, 2022
18.1K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

· Option 1:

1. Click the triangle in the top left corner to select the entire table.

2. Click the Home tab the Rows and Columns drop-down button AutoFit Row Height and AutoFit Column Width.

3. The row height and column width can be adjusted according to the characters and numbers in cells.

· Option 2:

1. Click the triangle in the top left corner to select the entire table.

2. Click the Home tab the Rows and Columns drop-down button Row Height and Column Width.

3. In the pop-up dialog, we enter the specific value, and click the OK button.

4. Then, we can expand cells to fit the text.

· Option 3:

1. Place the cursor at the cells column heading right border or row heading lower border.

2. When the cursor becomes a left-right arrow or up-down arrow, double click it.

3. Then, we can expand cells to fit the text.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.