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....

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....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

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 format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

You will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint.Learning to align the shapes in WPS Presentation can make the layout easier. So how to use the function of Align?Select the shapes to be aligned, click the Drawing Tool tab, and then click the Align button. In the Align drop-down menu, you can set the alignment as needed.Note: same alignment settings show different effects with different reference objects. Here are three different wa....

When entering text in WPS Writer, we often need to add some unique icons in the text to visualize the content. You can join a WPS membership to download free icons from the vast icon library. Head to the Insert tab and click the Icon Library button. Here we have several options as Recommended, Business, Education, and other types of icons.You can choose an icon style you like, and click the desired icon to insert into the document quickly after entering the details page. If we need to....

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Take this presentation as an example. In order to better explain the contents, I will insert a table into this slide. Click Object in the Insert tab. A dialogue box will pop up, where we could select Create new or Create from file.In the Create new interface, we can select different types of blank documents at the Object type, but we need to edit them manually. In the Create ....

Adding bullets to the text content can play a role in highlighting and make our slides look more layered. So, how can we add bullets? Select the text content that needs to be added with bullets, click the Home tab above, and then click the Bullets button. Here, we can see the various preset bullets animations provided by WPS. We can also set the color and size of the bullets as needed.If there is no required bullet, we can click Bullets first and then click More Bullets. In the pop-up ....