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

        1740 results for protect cells in excel

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

        1740 results for protect cells in excel

        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.4K views
        Set password to protect privacy in WPS spreadsheet

        Set password to protect privacy in WPS spreadsheet

        02:03

        Set password to protect privacy in WPS spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....

        Spreadsheet 27.7K 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.1K views
        Merge and split table cells in WPS Writer

        Merge and split table cells in WPS Writer

        01:09

        Merge and split table cells in WPS Writer

        Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....

        Writer 17.0K views
        Use the text function to extract characters in cells

        Use the text function to extract characters in cells

        02:45

        Use the text function to extract characters in cells

        In this video, we'll introduce three practical functions in excel, which are the RIGHT, LEFT, and MID functions.In this example, if we want to extract the first three numbers on the right, how can we realize it? The RIGHT function could help. It can extract characters within a cell, from the right to the left. Here is the complete formula of the RIGHT function. RIGHT(text,num_chars) The first parameter text refers to the specific text to be extracted. The second parameter num_chars....

        Spreadsheet 9.5K views
        Format Cells Locked and Hidden

        Format Cells Locked and Hidden

        01:21

        Format Cells Locked and Hidden

        When working with spreadsheets, what should we do if we want to hide and protect the formulas in the cells? Take this spreadsheet as an example, click the Review tab, then we can box the cells containing the formulas, right-click for the pop-up dialog, select Format Cells. Its shortcut key is Ctrl+1.Next, click Protection, check Locked and Hidden at the same time, and click OK. We sometimes find the Locked option in the dialog settings displaying as a black square, which represents unc....

        Spreadsheet 19.5K views

        How to count text cells in Excel

        How To Count Text Cells In Excel - WPS Academy Excel is a spreadsheet, and you need to count cells to do your job right. The spreadsheets, which typically contain cells with a combination of numbers and text, are an excellent way to store and analyze data. It's helpful to know how to count cells. This is because Excel doesn't always give you the information you need, and counting cells helps you figure out where that information is. For example, when you have a large list and....

        xls Spreadsheet 6.7K views

        How to make cells fit text in Excel

        How to Make Cells Fit Text in Excel- WPS Academy Excel naturally has a certain line height and section width, so if you enter anything that takes up more room than the allowed amount, you'll see that it spills out. To fit the message in the cell in certain circumstances, you can alter the lines and sections (with the goal that the message is totally inside the cell). We wish to modify a few things using some Excel components to create cells. Utilizing Autofit Row and Column, cells....

        xls Spreadsheet 7.9K views
        Prev 1 2 3 ... 217 218 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