WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to turn off autofill

    29 results for how to turn off autofill

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

    29 results for how to turn off autofill

    How to Turn Off Autocorrect

    The Autocorrect function in WPS Office can correct spelling and other mistakes when using it to edit documents.How can we turn off Autocorrect when we do not need it? 1. Click Menu on the upper-left corner, and choose Options.2. Get into the Edit tab in the Options dialog. 3. Change the relevant settings in the category of AutoCheck, and click OK to apply the settings. Here is an example of canceling the option of Capitalize first letter of sentences. Before turning off Autocorrect - &....

    Writer 0.2088 views
    Use the fill handle to quickly enter data

    Use the fill handle to quickly enter data

    02:59

    Use the fill handle to quickly enter data

    AutoFill can help us quickly enter some regular data, which is an essential skill in using WPS Spreadsheet to deal with different data. It includes Fill Numerical Value, Fills Data, Fill Text, Custom Text Filling, and Fill Formulas.Take this table as an example. If we want to fill in the numbers 1 to 10 in column A, select cell A2 and move the cursor to the lower right corner of cell A2. At this time, the cursor will turn into a small black solid cross. Press and hold the left mouse bu....

    Spreadsheet views

    How to turn off paragraph marks in word

    No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Today we will learn how to turn off paragraph marks in word, which will take away extraneous content in your content.1. Open your document in WPS Writer.2. Click the Menu tab > Options, then head to Formatting marks, where you can uncheck Paragraph marks. Finally, click OK.

    Writer views

    How to turn off automatic numbering in WPS Writer

    When editing documents, we sometimes don't want WPS Office to automatically number list for us every time we press the Enter key. So how can we turn off automatic numbering?1. First open the file in WPS Writer.2. Click the Menu button in upper lefter corner.3. Then select Options in the drop-down menu. Now a Options dialog box will pop up.4. Click Edit → and then check Auto numbered lists.5. Finally click OK.This skill could also be used in Microsoft Office Word and OpenOffice.

    Writer 0.1802 views

    How to turn on spell check in word

    · Option 1:1. Click the Menu button in the upper left corner, and click the Options to pop up a dialog.2. In the dialog, click Spell Check and check the Check spelling as you type.3. Finally, click the OK button. Then we can turn on spell check. · Option 2:1. Click the Review tab and click the Spell Check drop-down button, then the Check Spelling pane will pop up on the right side. Its shortcut is F7.2. When we click the wrong word with the cursor, the Suggestions will generate the cor....

    Writer 0.1394 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 views
    Use the ROUND function to round decimals quickly 

    Use the ROUND function to round decimals quickly 

    01:57

    Use the ROUND function to round decimals quickly 

    In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

    Spreadsheet 0.1363 views
    INDEX MATCH formulas

    INDEX MATCH formulas

    02:11

    INDEX MATCH formulas

    In the previous videos, we've learned about the usages of INDEX and MATCH formulas, respectively.The INDEX function can return a value in a cell regarding its column and row number in an array. Combining the INDEX MATCH formulas makes it flexible in value lookup. We can break the limitations of VLOOKUP and realize the reverse lookup. Here is a form recording the personal information of staff. How can we look up the 'Number' of a corresponding staff? We can run the INDEX MAT....

    Spreadsheet views
    Prev 1234 Next
    WPS Academy
    Products
    Partners