Download WPS Office for your device
Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

Download WPS Office for All Platforms
Find your device and get the right version
- Choose your platform
- Download WPS
- Install and launch
Search Results
465 results for how to adjust column width in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
465 results for how to adjust column width in excel
Quickly adjust the row height and column width
01:36Quickly 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 ope....
Adjust row height and column width of tables in word
02:02Adjust row height and column width of tables in word
When making tables in word, we often need to set their accurate row height and column width. In this video, you'll learn how to adjust table row height and column width in word. · Row height:Select the table for settings. Next, get into the Table Tools tab and click Table Properties. Go to the Row tab of the pop-up dialog. Then, we can adjust the row height at Size. After checking the Specify height option, enter ’0.5’ in the input box. In the category of Row height is..., we can c....
How to adjust the overall width and font position of the table in WPS Writer
01:33How to adjust the overall width and font position of the table in WPS Writer
After we create the table in a document, we can adjust the size of the cells and the position of the text in the table.Take this table as an example. We move the mouse cursor to where the table is located and click the cross button in the upper left corner to select all cells. Click the Table Tools tab and the Table Properties button, then a dialog box will pop up.In the Cell tab, find Size and check Preferred width. We can also adjust the width of all cells after entering the value ac....
How to adjust the picture position
02:06How to adjust the picture position
After inserting a picture in the document, to perfect the layout, we will adjust the position of the picture in the process of typesetting. Take this document as an example. If we want to move the picture to the lower right corner of the page margin, click the picture first. Then click the Layout Options button in the upper right corner of the picture. And then click View More, now the Layout dialog box will pop up. WPS has provided us a large variety of alignment methods in the Positi....
Adjust shape fill in WPS Presentation
01:33Adjust shape fill in WPS Presentation
When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. How can we change the design of shape fill and outline? Left-click the inserted shape, and get into the Drawing Tools tab. Then click the Shape Fill button. There are two options. One is to choose the default style provided by WPS Office,....
Adjust shape outline in WPS Presentation
01:41Adjust shape outline in WPS Presentation
When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. How can we adjust the outline for an inserted shape? Left-click the shape, and get into the Drawing Tools tab. Then, click the Shape Outline dropdown button to change the settings of the shape outline, including colors, thickness, and outline style. To change the outline color, we can either choose one from the default styles provided by WPS ....
Use format painter to adjust the styles in batches
01:28Use format painter to adjust the styles in batches
Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....
How to adjust line spacing of the text
01:18How to adjust line spacing of the text
After we finish editing the text content, we need to adjust the font size and line spacing of the text in order to make it easy to read. So how can we adjust line spacing of the text? Take this document as an example, select all the text content, then click the Line Spacing button of the Home tab. Users can select the amount of line spacing here according to their needs. If there are is no proper options, users can also set line spacing by themselves. 1.Click the Line Spacing button o....