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
220 results for excel activex control properties
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
220 results for excel activex control properties
How to set the table properties in WPS Writer
02:19How to set the table properties in WPS Writer
After we insert the table in the document, we may want to set the table. So how are we going to do that? Take the table in this document as an example. The width of the table is too long. If we need to adjust it, just click the cross cursor in the upper left corner of the table. Select the entire table, click the Table Tools tab, and click the Table Properties button. Now we can see a dialogue box has popped up. In the Table tab, we can enter an appropriate value in Size to adjust the....
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 display the obscured table text in WPS Writer
01:56How to display the obscured table text in WPS Writer
When a table is inserted in a word document, the text in the table may not display completely. Do you know how to fix it? l Case 1: Table exceeds page sizeWhen we copy the table in other platforms to insert it into the document, and the table exceeds the page width, the text on the right of the table will be incomplete.In most cases, we can use the mouse to slowly drag the box line to adjust to the appropriate position, which is too troublesome.Here is a practical trick helping you ad....
How to convert Excel to PDF
02:50How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
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....
Create a chart from scratch
08:59Create a chart from scratch
In this lesson we have studied the following key points:1. How to create table borders and insert a diagonal line to the table header.l You can click the "Drow border" button to draw the form lines manually, or you can click the "All borders" button, which provides many border styles.l Select the targeted cell first, press the shortcut key "Ctrl+1", select "Border" >select a diagonal line border. 2. How to merge or unmerge cells.WPS Spreadsheet also provides more ways of merging cells....
How to insert and set pictures in WPS Spreadsheet
02:19How to insert and set pictures in WPS Spreadsheet
When using WPS Spreadsheet, we often need to add pictures for a more visual presentation. So how can we insert a picture into the table? Select the cell where you want to insert a picture, click the Insert tab, and then click Picture. Here we can choose Floating Picture or Embed to Cell. Floating Picture allows pictures to float above cells, then we can move and resize the picture at will. Embed to Cell is to pin the picture within a cell. We can't move the picture but only control....
Use PivotTable to analyze data 2
10:15Use PivotTable to analyze data 2
1.Introduces several causes of pivot table errors.We should standardize the original table. Blank cells in fields, irregular dates format, merged cells, or numerical texts in numerical values will trigger errors.2.Introduced the basic rules of using pivot charts.PivotChart can show the data trend. The X-axis will show the fields in ROWS, while the Y-axis will present the fields in VALUES.3.Slicer can show your leader what they want to see, including fields that aren't in the PivotT....