20 results for how to turn off autofill
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
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 - &....
Use the fill handle to quickly enter data
02:59Use 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....
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.
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.
How to add a cover page in WPS Writer
00:47How 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....
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....
Use the ROUND function to round decimals quickly
01:57Use 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....
INDEX MATCH formulas
02:11INDEX 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....