How To Expand Cells To Fit Text In Excel | WPS Office Academy

Free Download Top Searches Login/Sign up Login/Sign up Top Searches WPS Office

Free All-in-One Office Suite with PDF Editor

Edit Word, Excel, and PPT for FREE.

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

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

Select areas that need to improve

• Didn't match my interface
• Too technical or incomprehensible
• Incorrect operation instructions
• Incomplete instructions on this function
• Other

Fields marked * are required please

Please leave your suggestions below

Submit Cancel

• Home
• Quick Tutorials
• WPS Spreadsheet
• Data Entry and Editing
• Cell Editing

How to expand cells to fit text in Excel March 27, 2025 56.2K Views 52

· 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.

Free Download 100% secure

Also Read:

• 1. How to make excel cells expand to fit text automatically in excel
• 2. How to Adjust Excel Cells to Fit Text
• 3. How to add line of best fit in excel on mac
• 4. Easy Shortcut: How to fit text to cell in Excel
• 5. How Many Words Fit on a Page
• 6. Collapse or expand rows or columns in a sheet

Algirdas Jasaitis

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

Free Download WhatsApp Messenger Gmail Mail Copy Link Submit close