WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how wireless communication changed the world

    59 results for how wireless communication changed the world

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    59 results for how wireless communication changed the world

    Use Validation to restrict data change

    Use Validation to restrict data change

    02:24

    Use Validation to restrict data change

    We want to lock the cells after checking the table data and prevent it from being further changed. What can we do?In today's tutorial, you will learn how to use the Validation function to restrict data change.Step one, select the E column, and then add a drop-down list named checked.Click Validation at Data, and you can also use the shortcut Alt+D+L.In the Setting tab, select List at Allow, and enter checked at Source. Finally, click OK.By doing so, we can select checked in the dro....

    Spreadsheet views
    How to align fonts in WPS Presentation

    How to align fonts in WPS Presentation

    01:09

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

    Presentation views
    How to set the text direction in WPS Writer

    How to set the text direction in WPS Writer

    01:47

    How to set the text direction in WPS Writer

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

    Writer views
    How to quickly update the table of contents

    How to quickly update the table of contents

    01:10

    How to quickly update the table of contents

    How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

    Writer 0.1004 views
    Track changes

    Track changes

    01:30

    Track changes

    Excel worksheets are frequently used for teamwork. We want to record and track the modifications made by each member. Today, we will learn how to use the "Track Changes" function.Take this table as an example, we want to get the revision history of the data.First, go to the "Review" tab, and click "Highlight changes" at "Track Changes."Then, check "Track Changes While Editing" to track the changes in your sheet. By doing so, you can highlight the changes including time, reviser, and r....

    Spreadsheet views
    Set the date format cells

    Set the date format cells

    01:40

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

    Spreadsheet 0.393 views
    Refresh pivotTable and change data source

    Refresh pivotTable and change data source

    01:28

    Refresh pivotTable and change data source

    If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....

    Spreadsheet views
    How to set the slide size in WPS Presentation

    How to set the slide size in WPS Presentation

    01:28

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

    Presentation 0.2183 views
    Prev 123...78 Next
    WPS Academy
    Products
    Partners