465 results for All
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
465 results for All
How to insert an attachment in WPS Spreadsheet
01:28How to insert an attachment in WPS Spreadsheet
When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....
More features in Picture to Text
02:12More features in Picture to Text
Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....
How to customize the ribbon in WPS Presentation
02:57How to customize the ribbon in WPS Presentation
WPS Presentation's built-in tabs in ribbon enable users to explore different functions. We can also customize the ribbon to meet different work demands. · Hide and show the toolbarClick the Hide the toolbar or show the toolbar button in the upper right corner, and you can make the ribbon display or disappear. If Hide the toolbar is selected, you can click any tab to make it display temporarily. · Create customized ribbons and groupsClick Menu, and then click Option to select Custom....
How to efficiently sort and filter data part
13:31How to efficiently sort and filter data part
Sort and AutoFilter can help us arrange and select data.1.We can set single condition sort and multi-condition sort, as well as create specific sorting rules on our own.2. In the part of AutoFilter, we shared some basic functions such as value filter, filter by text, date, and color, and advanced filter. In the Advanced filter, we can set "simultaneous satisfaction,'" and "partial satisfaction." We can also filter the unique data record.3. The AutoFilter function in WPS Spreadsheet....
How to customize the ribbon in WPS Writer
02:33How to customize the ribbon in WPS Writer
WPS Writer's built-in tabs in ribbon enable users to explore different functions. We can also customize the ribbon to meet different work demands. · Hide and show the toolbarClick the Hide the toolbar or show the toolbar button in the upper right corner, and you can make the ribbon display or disappear. If Hide the toolbar is selected, you can click any tab to make it display temporarily. · Create customized ribbons and groupsClick Menu, and then click Option to select Customize Ri....
Use Validation to restrict date entries
01:10Use Validation to restrict date entries
When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcuts Alt+D+L.The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less ....
Set the date format cells
01:40Set the date format cells
In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....
Print page setup in WPS Spreadsheet
01:20Print page setup in WPS Spreadsheet
When we need to print a table, if we are not satisfied with the effect of the currently displayed page, how can we quickly set up the page? Take this table as an example. Click Print Preview in the quick access toolbar to enter the print preview interface. Click the Page Setup button, then the Page Setup dialog box will pop up. In the Page tab, we can adjust the Orientation and Scaling of the page and the related settings of the printer. In the Margins tab, we can precisely adjust the....