Download WPS Office for your device

When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

When projecting slides with WPS Presentation, we sometimes hide some of the slides for better projection effect.The hidden slides cannot be projected or printed. So how can we print them without changing their hidden state?Take this slide as an example. In the thumbnail on the left of the screen, you can see a small delete icon at the slide page number, indicating the slide is hidden.You need to click the Menu button in the upper-left corner and click Print.Click the check box Use the ....

Switching back and forth between different workbooks is inconvenient for checking data. Today we will tell you how the View side by side function can help.For example, suppose we want to check whether the data in March is identical in the Quarterly Sales and Monthly Sales sheets. Click the View side by side in the View tab. The interface will then be divided into two sections, one on the left and one on the right. The quarterly sales sheet is on the left while the monthly sales sheet i....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Do you still jump back and forth between two documents when you need to compare the revision between them? At this time, we can place the two documents in the same interface with the help of View Side by Side. Let's take these two documents as an example, one is the original document, and the other is the revised document. Open either of thes....

In WPS Spreadsheets, there are two ways of splitting sheets: Split Sheets By Content and Split Books By Sheet. First, Split Sheets By Content.Take this table as an example. We want to split this table into multiple sheets by month. Click the Data tab, click the Split Sheet drop-down button and select Split Sheets By Content. The default Split area is the whole table. Check My data has headers to make the split sheets have titles. Since we want to split the table by month, we select "Mo....

In the process of using WPS Office, we can set the overall view effect of WPS components for personal use. Take the components in WPS Writer as an example. Click Menu and choose Options. At this time, a dialog box will pop up. In the left tab, the first one is View. In this interface, we can set Show, Print, options, Formatting marks and Ribbon options. +In the Show box, we can set Status bar, Mini Toolbar. +In the Print options box, we can set the content that needs to be displayed. F....

When using WPS Presentation, we can set the view effect according to our personal preferences and habits.Click Menu and choose Options.In the popup dialog, click View.In this interface, we can set up Show, Thumbnail and outline position, Slide show and Ribbon options. In the Show area, we can check the elements that need to be displayed, such as Startup task window, Status bar, Vertical ruler and so on. Then, click OK to change the view settings. In addition, we can also check Show Min....

When working with spreadsheets, what should we do if we want to hide and protect the formulas in the cells? Take this spreadsheet as an example, click the Review tab, then we can box the cells containing the formulas, right-click for the pop-up dialog, select Format Cells. Its shortcut key is Ctrl+1.Next, click Protection, check Locked and Hidden at the same time, and click OK. We sometimes find the Locked option in the dialog settings displaying as a black square, which represents unc....