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

        530 results for secret code for i love you

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

        530 results for secret code for i love you

        More features in Web search function

        More features in Web search function

        01:08

        More features in Web search function

        Today I will tell you the differences in the web search function between Microsoft Word and WPS Writer. When we use Microsoft Word to edit a document, we usually copy the content and open a browser to search for it if we encounter content that we do not understand. And when you use WPS Writer, you can skip this step. WPS Office has a built-in Google search engine in WPS Writer, so you only need to select the text you want to query and then click the Search button in the lower right cor....

        Writer 9.0K views
        SUBTOTAL function: Calculate the data with the hidden value

        SUBTOTAL function: Calculate the data with the hidden value

        02:33

        SUBTOTAL function: Calculate the data with the hidden value

        Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

        Spreadsheet 23.9K views
        How to set the header row across pages

        How to set the header row across pages

        00:50

        How to set the header row across pages

        When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

        Writer 9.7K views
        Elementary arithmetic functions in WPS Spreadsheet

        Elementary arithmetic functions in WPS Spreadsheet

        02:50

        Elementary arithmetic functions in WPS Spreadsheet

        Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....

        Spreadsheet 13.5K views
        Adjust the article structure in the outline view mode

        Adjust the article structure in the outline view mode

        03:01

        Adjust the article structure in the outline view mode

        When we edit a long article, we need to adjust the structure of the article. For example, we need to move parts of the content and quickly change the heading level. But, scrolling and searching page by page is time-consuming. At this point, we can switch to the outline view mode.Go to the View tab, and click the Outline button to switch to the outline view mode. First, I will show you what is displayed on the page in this view mode.1. In the ribbon above, we can adjust the level of the....

        Writer 8.9K views
        Set Allow Users to Edit Ranges in a protected sheet

        Set Allow Users to Edit Ranges in a protected sheet

        02:04

        Set Allow Users to Edit Ranges in a protected sheet

        As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

        Spreadsheet 10.0K views
        Custom cell formats

        Custom cell formats

        03:48

        Custom cell formats

        When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

        Spreadsheet 8.4K views
        How to add a cover page in WPS Writer

        How to add a cover page in WPS Writer

        00:47

        How to add a cover page in WPS Writer

        WPS Writer is a terrific tool for adding a cover to your resume or report if you want them to have a great impression on others. How can we add a cover page to a document?We can turn to Cover Pages in the Section tab or click Cover Pages in the Insert tab. Click the Cover Pages button in the drop-down list, and we can see that there are different kinds of covers to choose from, including Business, Resume, Thesis and Transverse. After selecting the cover page, we can change the build-i....

        Writer 15.5K views
        Prev 1 2 3 ... 66 67 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