Using Automatic Fit

Spread Silverlight supports AutoFit in columns and rows. AutoFit automatically sizes the column to fit the contents by adjusting the column width or automatically sizes the row to fit the contents by adjusting the row height. AutoFit ignores the header text.

Double-click the right edge of the column header to resize the column to fit the longest string of text in the column.

Double-click the bottom edge of the row header to resize the row. The WordWrap property must be true.

You can also select multiple columns or rows or the entire sheet and double-click on one selected column or row to apply AutoFit to all the selected columns or rows.

AutoFit works with merged cells, hidden columns and rows, filtered columns and rows, grouped columns and rows, and selected columns and rows that are not shown in the viewport. AutoFit is not applied if the CanUserResize property is false for the column or row.