WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to expand cells to fit text in Excel

January 5, 2022
41.0K Views

· 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 cell’s 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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.