- All Tutorials
- Video Tutorials
- Quick Tutorials
640 Search results
Hyperlink in WPS Office Spreadsheet02:22
Hyperlink in WPS Office Spreadsheet
When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....
Set the page printing area in WPS Office Spreadsheet00:47
Set the page printing area in WPS Office Spreadsheet
What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....
Rows and columns tools in WPS Spreadsheet02:34
Rows and columns tools in WPS Spreadsheet
Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....
How to insert and find bookmarks in WPS Writer01:13
How to insert and find bookmarks in WPS Writer
No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....
Merge and split table cells in WPS Writer01:09
Merge and split table cells in WPS Writer
Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....
Clear and avoid duplicates entries in WPS Spreadsheet01:56
Clear and avoid duplicates entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....
Change paper orientation and size for printing01:20
Change paper orientation and size for printing
How can we change the paper orientation for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice. Take this word document as an example. 1. Get into the Page Layout tab, where we can find the Orientation and Size buttons.2. Click the Orientation button. Then, we can choose either Portrait or Landscape as the page orientation.3. Click the Size button. Then we can see several default styles of paper sizes provided by WPS Office. I....
How to insert and set a text box01:44
How to insert and set a text box
When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....