How to Allow Excel to Automatically Change Row Height

When you export a document that contains a Grid/Graph to Excel, sometimes the data can be too long to fit inside an Excel cell. The text wraps within the cell, but the row is too short and cuts off the text. If this occurs, you can allow Excel to dynamically and automatically resize rows, so that they are tall enough to display the full text.

By default, all rows are the same height, to conserve the same layout that you created in the document. Steps are below to allow Excel to automatically change the row height for Grid/Graphs in a document section.

To allow Excel to automatically change the row height for a section in a document

1. Open the document in Design Mode.

   • From a folder, right-click the document and select Edit.
   • If you are viewing the document in Presentation Mode, click the menu icon on the right, and select Edit.
2. In the Layout area, select the document section to modify.
3. From the Format menu, select Properties and Formatting.
4. From the left, click Layout.
5. Select the Automatically fit rows checkbox.
6. Click OK.