986 results for wps office old version
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
986 results for wps office old version
Hyperlink in WPS Office Spreadsheet
02:22Hyperlink 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 Spreadsheet
00:47Set 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....
How to Add Fonts in WPS Office Word
Welcome to WPS Official Academy to check the contents of how to insert fonts in WPS Office word. What is WPS Office?WPS Office is the best alternative to Microsoft 365. WPS Office Suite supports both PC and Mobile, installs the latest versions (11.2.0.10443) online and is compatible with Microsoft Office, Google Docs and Adobe PDF. Before adding fonts, please check your version first.Head to the WPS Office interface > click Settings above > About WPS Office, and then you can check wh....
How to create a Form in spreadsheet
01:26How to create a Form in spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....
How to insert a background image and print it out in WPS Spreadsheet
01:31How to insert a background image and print it out in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....
Add animated characters in WPS Office PowerPoint
In this article, you will know how to add animated characters in WPS Office PowerPoint with simple steps as following: A dynamic presentation helps to keep the audience interested. So how can we add animated characters to a slide to make it more elegant? Let’s have a try step by step. Here we take a WPS Office introduction presentation as an example.1. Add the text you need to the slide.2. Select the text, head to the Animation tab and choose an animation from the box. 3. Then you can....
Typewriter effect in WPS Office PowerPoint
Welcome to WPS Official Academy to check the contents of Typewriter effect in WPS Office PowerPoint. The Typewriter effect is one of the amazing animations to make a perfect presentation. So how can we make a typewriter effect? Let’s have a try step by step. If you want to make a vintage typewriter look, we recommend going with a Courier New font in black.1. Insert a text box and input the content that you need.2. Set the font size as needed, and then set font style and font color. 3.....
How to use autosum in excel of WPS Office
How To Use Autosum in Excel of WPS Office KEYWORD: How to use autosum in excel Excel's AutoSum function, in its most basic version, computes total in your spreadsheet by automatically entering a formula. This fantastic function not only provide accuracy but also save your time. This brief lesson provides an explanation of how to use AutoSum in excel and demonstrates the most effective methods for using AutoSum in Excel. You will learn how to automatically sum columns or rows by us....