To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

When using WPS Spreadsheets, we can use the Fill Color tool to change the cell color. Are there any other methods to change the table style quickly? WPS Spreadsheets can realize it with its Format as Table function. 1. Select a cell range to be set. Get into the Home tab and click Format as Table to show its dropdown menu, where we can choose one from the default formats. 2. Left-click on any of the formats. Then, we can see the Format as Table dropdown menu. 3. Check the option titled....

When editing a document, we can mark specific contents quickly with the following features.· Change CaseTake this document as an example. If we want to change the case of the selected contents, click Change Case in the Home tab.In the pop-up dialog, we can select Lowercase, Uppercase, and Capitalize each word, etc., according to our needs. · Enclose CharactersIf we want to enclose a character, such as a number in the document, select it and click Enclose Characters in the Home tab.In t....

Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

When we are making slides, we often need to insert multiple pictures. When there are too many pictures, the file size may increase, and the transmission speed will slow down.As is shown in this video, here are two presentation files with the same content. The file that has used the Compress Picture feature has a significantly smaller size than the other one. So how can we compress pictures?1. Click to select the picture.2. Then click the Compress Picture button in the Picture Tool tab ....

Usually, when editing a document, the text is input horizontally from left to right by default. In the following video, we will teach you how to change the direction of the text. First, select the text that needs to be changed, and click the Text Direction drop-down button in the Page Layout tab. Here, we can see six styles in the list. 1.Horizontal Text Box: This is the default text direction in WPS Writer. 2.Vertical from right to left: At this time, the text is vertical and aligned ....

Within the same text box, we can align different texts in different ways. Today, we will learn how to set them. Take this text as an example. When we decrease the font size of part of the text, we will find that the typesetting between these fonts with different sizes has changed. This is because they are set differently in Align Font.Select the text box, get into the Text Tools tab, and click the Align Font drop-down button.Select Roman, and both texts will be aligned according to th....

Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....