Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Quickly adjust the row height and column width
Uploaded time: September 27, 2021 Difficulty Beginner
Quickly adjust the row height and column width
Quickly adjust the row height and column width
Adjusting the row height and column width is a necessary skill for the layout of the table content. So, how can we adjust the row height and column width?
The easiest way to adjust the row height and column width is to position the mouse on the dividing line of the row number and column label and drag the dividing line to adjust the row height and column width. We will find that using this method is difficult to completely unify the row height and column width in the table, and the operation is complicated.
So how can we quickly adjust the same row height and column width?
First, we click the triangle symbol in the upper left corner of the table to select all the table. At this time, when we drag any one row height and column width, the row height and column width of the entire table will be adjusted in the same way.
We can also quickly set the most appropriate row height and column width. Move the mouse to the dividing line of the row or column, and double-click to complete the automatic adjustment of the row height and column width.
What if we need to set the row height or column width precisely? Take this table as an example. In the Rows and Columns drop-down menu, click Row Height, then we can see that the height of the row is 19.8. Select the table area we want to adjust, click the Rows and Columns drop-down menu, choose the Row Heightoption, enter 19.8, and finally click OK.
Make your work easier with WPS Spreadsheet like Microsoft Excel. Did you get it?
Also Read:
- 1. Use the ROW function to mark the row number
- 2. Use the text function to extract characters in cells
- 3. WPS Spreadsheet basic editing
- 4. Edit settings in WPS Spreadsheet
- 5. Adjust row height and column width of tables in word
- 6. How to adjust the overall width and font position of the table in WPS Writer
Does this video help you?