More features in Reading Layout

Faced with huge amounts of data, we find it difficult to locate the selected cell or cells range. At this point, Reading the Layout can help a lot. Microsoft Excel doesn't support reading mode without plug-ins, while WPS Spreadsheets has the function of Reading Layout. Take this table as an example. 1. Click the View tab, and click the Reading Layout button to select a preferred color.2. When you click a cell, the row and column it lies in are highlighted. You can easily find the s....

More features in Split and Merge

In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

Unique features in Eye Protection Mode

WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.Long-time staring at the screen when using office software can cause eye irritation. At this point, we can relieve tired eyes by adjusting the theme or colour of the document. Eye Protection Mode is not available in Microsoft Office yet. But we can adjust the theme colour to relieve eye strain.Click File, then get into the Options inter....

How to add gridlines and guides in WPS Presentation

When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....

Use Date function to convert date format

We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

How to use the Arrange All function in WPS Presentation

We may need to refer to multiple documents when editing slides, but it is troublesome to switch back and forth. At this point, we can use the Arrange All function to display multiple documents at the same time. 1. Click the View tab and click Arrange All.2. Here we select Tile Horizontal. Then the currently open presentations can be identified intelligently and arranged in a horizontal tile. 3. According to personal habits, we can also select Vertical Text Box, or Cascade.4. If we want....

How to print slides in black and white

Printing black and white slides helps to reduce printing costs and save resources. Next, I will share how to print black and white slides with you.Take this slide as an example. Click the Print Preview shortcut button at the top left of the screen.At this point, the slide shows the colored style.Click the drop-down button of Color above, and then click Pure Black and White so that the slide is set to be printed in black and white.In addition, we can also set the printing color in the P....