In your second AUTOFIT, the range should be the range of the data. Or, select the column (s) you want to adjust, click the Home tab on the ribbon, click the More button in the Records group, select Field Width, enter the column width and click OK. STEP 2: Make sure Sheet2 is selected as we want to autofit the columns there. Set the column width of the Kendo UI Workbook to autoWidth by adding a handler to the excelexport event of the Grid. It will autofit the columns so that all the data is shown. STEP 3: Let us test it out! Open the sheet containing the data. That will adjust the column width to accommodate the widest cell, but no more. Finally, you can autofit multiple rows at the same time using both methods. Watch the status bar for a progress counter.
On the Home tab, in the Cells group, click Format. Autofit in excel To AutoFit rows in Excel, select one or more rows, and do one of the following: Method 1.
