How to align fonts in WPS Presentation

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

Set the date format cells

In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

Use VLOOKUP function to create dynamic charts

In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

How to set the slide size in WPS Presentation

When using WPS Presentation to make slides, we need to set the slide size first. So how can we set the slide size? First, click the Design tab above, and then click the Slide Size button. Here, we can quickly adjust the slide size, such as the commonly used Standard Screen 4:3 or Wide Screen size 16:9.If we need to set other sizes, we can click Custom Size to open the Page Setup dialog box for more detailed slide settings. By clicking the Page Setup button in the Design tab, we can als....

Fill handle: Use Ctrl+D to fill

We sometimes need to deal with tables containing various content. Then we may find it troublesome even to use the fill handle to pull down and fill. Here, we will introduce two convenient methods to you. The first method is to double-click the fill handle. After filling the first data in column A, double-click the fill handle, then the data will be automatically filled in sequence order. Now we can see the data has been filled automatically in the row range of column B. In the digital ....

How to add a watermark

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

How to use the comment feature in WPS Writer

When reviewing documents, we often need to use the comment feature. So how can we add comments? Take this article as an example. For instance, we want to add a comment to the first paragraph: The beginning of this article can be a little more concise. First, place the mouse cursor at the beginning of the paragraph, click New Comment in the Review tab. Now a comment box will pop up on the right side of the page. Here, we can enter the comment content. If we want to add comments to a sp....

How to set the Layout Format

The Page Layout function of WPS has aimed at the articles containing section breaks, the position setting of the header and footer, and the change of the measurement unit of the document. Take this document as an example. We will explain its features to all of you.· SectionThis is a document containing a section break. We can first click the Section Navigation Pane button in the Section tab, and then we can see the article is divided into four sections in the navigation pane on the lef....