How to Autofit Row Height to Show all Contents

– How to Setup the Row Height

When the rows in Excel are too narrow, you may not see all the contents. Please follow the steps below to use autofit to quickly expand the row height to show all the cell contents.

Step 1: Select rows that you need to adjust row height;

Step 2: Double click when the cursor turns to a black cross;

Step 3: The hidden contents in the cells will appear.

Alternatively, please use commands in the ribbon:

Step 1: Select rows that you need to adjust row height;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Format" in the Cells area, and select "Autofit Row Height" from the drop-down list.

Leave a Reply