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

        170 results for how to turn off scroll lock excel

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

        170 results for how to turn off scroll lock excel

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

        doc Writer 23.6K 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.

        doc Writer 15.1K views

        How to lock excel file from editing

        How to Lock Excel File from Editing Keyword: Lock Excel File from Editing Do you have confidential information that you do not want other people to be able to change? If this is the case, you will need to be familiar with the process of protecting Excel files from being edited. This could be a very crucial step in the process of preserving the safety of your data. In the following paragraphs, we will demonstrate how to carry out the task. It is a fairly straightforward process that can....

        xls Spreadsheet 7.0K views

        How to cut off text in excel

        How to cut off text in excel -WPS academy When you are reading a Microsoft excel file, you've probably noticed that there is a lot of extra content in the top and bottom of the columns. This can be very annoying when you're trying to access a specific column or row on your spreadsheet. Cutting off text in Excel is one of the most common actions - whether you're extracting a part of a cell, or want to create a table from your data. There are different ways to do it and in....

        xls Spreadsheet 31.3K views

        How to use $ to lock cell in excel

        If you wish to prevent editing of cells, you can lock them in Excel. Lock all cells using $ in excel online, 2016 and 2019: All cells are locked by default. However, unless you safeguard the worksheet, locking cells has no effect. Just select all cells. Format Cells can be selected by right-clicking or by pressing CTRL + 1. You can check to see if all cells are locked by default on the Protection tab. Click on ok or on cancel. Protect the sheet. Now that all cells are locked. Right-cli....

        xls Spreadsheet 5.1K views
        How can we protect a worksheet in WPS Spreadsheets

        How can we protect a worksheet in WPS Spreadsheets

        01:49

        How can we protect a worksheet in WPS Spreadsheets

        Do you know how to lock cells in WPS Spreadsheet so that they cannot be modified by others? Take this table as an example. 1. Click the Review tab. 2. When finding that the Lock Cell button is gray, it means that the entire table is now locked. At this point, click Protect Sheet. 3. Check the Select Locked cells and Select Unlocked Cells options in the pop-up dialog box. 4. Enter a password and click OK to confirm. Then we will find that the form cannot be edited.What needs to be aware....

        Spreadsheet 12.3K views
        How to lock and unlock cells in WPS Spreadsheet

        How to lock and unlock cells in WPS Spreadsheet

        01:35

        How to lock and unlock cells in WPS Spreadsheet

        If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

        Spreadsheet 27.0K views
        Relative reference, absolute reference, and mixed reference

        Relative reference, absolute reference, and mixed reference

        03:46

        Relative reference, absolute reference, and mixed reference

        When copying formulas to other cells, we might encounter three reference modes, namely relative reference, absolute reference, and mixed reference. We need to choose the proper reference method according to the specific calculation requirements and the formula. · 1. Relative ReferenceWhen copying formulas to other cells, the formula will change according to the position of the referenced cell.Take this table as an example. Enter =B2*C2 in cell D2, and then pull down the fill handle to ....

        Spreadsheet 8.6K views
        Prev 1 2 3 ... 21 22 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