Feature Summary
The row height and column width feature supports adjusting the sheet layout through menu settings, right-click operations, and manual dragging, helping users flexibly control row and column dimensions and enhance data presentation.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Adjust via the "Row & Column" Menu
Feature Entry
"Insert" tab → "Row & Column" dropdown button
- Select the row or column you want to adjust
- Click the "Row & Column" dropdown button in the "Insert" tab
- In the dropdown menu, you can perform the following row height and column width settings:
- "Row Height": Enter a value to precisely set the row height (unit: points)
- "Best Fit Row Height": The system automatically adjusts the row height based on content height
- "Column Width": Enter a value to precisely set the column width (unit: characters)
- "Best Fit Column Width": The system automatically adjusts the column width based on content width
- "Standard Column Width": Reset the column width to the standard default width
4.Entering the target value in the corresponding value box to apply

Adjust via the Right-Click Context Menu
Feature Entry
Right-click on the row number/column header
- Select the target row or column, right-click to open the context menu
- Available operations:
- Right-click on the row number: Select "Row Height" to enter a value and adjust the row height, or select "Best Fit Row Height" for automatic adjustment
- Right-click on the column header: Select "Column Width" to enter a value and adjust the column width, or select "Best Fit Column Width" for automatic adjustment
- Entering the target value to apply

Adjust by Manual Dragging
Feature Entry
Drag the row/column border
- Select the target row or column, move the mouse to the row/column border until the "←→" indicator appears
- Click and drag to increase/decrease the row height or column width
- Release the mouse to apply to the sheet
- To batch adjust row height/column width, select multiple rows/columns

FAQ
Q1: What should I do if the row height value is inaccurate after setting?
- Solution: The row height unit is "points" (1 point ≈ 0.035 cm). If you need an exact centimeter value, convert ita before entering.
Q2: Why are all row heights/column widths the same after batch adjustment?
- Solution: Dragging the divider sets all selected areas to the same size. If you need to adjust them individually, drag row by row/column by column or use "Best Fit Row Height" for automatic adjustment.
Notes
- The maximum column width is 255 characters, and the maximum row height is 409 points
- "Standard Column Width" is only available in the "Insert" → "Row & Column" menu, and is not included in the right-click context menu
- Using "Best Fit Row Height/Column Width" can automatically adapt to multi-line or wide text content.
- The settings in the "Row & Column" menu are functionally identical to those in the right-click context menu, except that the "Row & Column" menu additionally includes adding/deleting rows and columns and standard column width.