To automatically adjust the column width based on the contents of the cell with the largest amount of data, do one of the following:
–Hover the mouse cursor over the right border of the column header so that the cursor takes the form of a two-sided arrow, and double-click.
–Right-click on the column header and execute the context menu command Fit width to content.
–Right-click on the column header and execute the Column width context menu command. In the Column width window, select Adjust automatically and click OK.
To automatically adjust the row height based on the contents of the cell with the largest amount of data, do one of the following:
–Hover the mouse cursor over the lower border of the header so that the cursor takes the form of a two-way arrow, and double-click.
–Right-click on the line header and execute the context menu command Fit height to content.
–Right-click on the row header and execute the Row height context menu command. In the Row height window, select Adjust automatically and click OK.
To automatically adjust the width or height of several columns or rows, follow these steps:
1.Select the required columns or rows.
2.Autofit width or height in one of the following ways:
•Hover the mouse cursor over the border between any two column/row headers in the selected range so that the cursor takes the form of a two-sided arrow. Double-click.
•Right-click on the header of any column or row in the selected range and execute the context menu command Fit width to content or Fit height to content.
•Right-click on the header of any column or row in the selected range and execute the context menu command Column width or Row height. In the window that opens, select Adjust automatically and click OK.
For each column/row in the selected range, the width/height will be selected according to the contents of the cell with the largest amount of data.