WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        246 results for how wireless communication changed the world

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

        246 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 6.2K 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 8.9K 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 19.2K 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 10.2K 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 17.4K 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 16.8K views
        How to add a watermark

        How to add a watermark

        02:14

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

        Writer 15.6K 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 46.8K views
        Prev 1 2 3 ... 30 31 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube