WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to lock formatting in excel

    2978 results for how to lock formatting in excel

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

    2978 results for how to lock formatting in excel

    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 6.6K views
    How to set the text outline in WPS Presentation

    How to set the text outline in WPS Presentation

    01:49

    How to set the text outline in WPS Presentation

    When creating slides with WPS Presentation, adding outlines to the specific text can beautify the text and make the presentation file look more professional. So, how can we add the text outline? Select the text, click the Text Tools tab, and click the Text Outline drop-down button. Here, we can set the Colors, Weight, Dashes of the Text Outline with just one click. If we want to further set the Text Outline, we can click the More Text Outline button. Then, the Object Formatting task pa....

    Presentation 1.8K views
    How to convert Excel to PDF

    How to convert Excel to PDF

    02:50

    How to convert Excel to PDF

    PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

    Spreadsheet 5.9K views
    How to set the background in WPS Presentation

    How to set the background in WPS Presentation

    01:38

    How to set the background in WPS Presentation

    Do you think the slideshow with a blank background is a little boring? If you want to make the slideshow look more beautiful, we can try to use the Background function in WPS Presentation. First, we click the Design tab above and then click the Background drop-down menu. Here, you can choose your favorite gradient fill preset. If we want to make more settings for the background, we can click Background. In the Object Formatting task pane that pops up on the right side of the screen, we....

    Presentation 4.0K views
    How to set character spacing in documents

    How to set character spacing in documents

    01:32

    How to set character spacing in documents

    When using WPS Writer for typesetting, we often need to adjust the spacing between characters. How can we adjust the character spacing?Take this document as an example. Select the text content, click Home in the upper menu bar, and choose Settings → Font. Then we can see the Font window. We can also press the shortcut key Shift+D to pop up the dialog. Get into the Character Spacing tab, and change the setting of Spacing. Here, we can choose one of the three default character spacing e....

    Writer 4.5K views
    How to enter a number starting with 0 in the Spreadsheet

    How to enter a number starting with 0 in the Spreadsheet

    01:38

    How to enter a number starting with 0 in the Spreadsheet

    The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

    Spreadsheet 3.1K views
    How to group objects in WPS Spreadsheet

    How to group objects in WPS Spreadsheet

    01:20

    How to group objects in WPS Spreadsheet

    In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....

    Spreadsheet 1.7K views

    How to lock cells in Excel

    1. Go to the Review tab.2. The Lock Cell button is grayed out, which means that the entire sheet has been locked by default.3. Click the Protect Sheet button, then a dialog will pop up.4. In the Allow all users of this worksheet to area, Select locked cells and Select unlocked cells these two options have been checked by default. (Note: Other options can be checked as needed.)5. We enter password in the Password (optional) box, and click the OK button.6. In the pop-up Confirm Password ....

    xls Spreadsheet 2.3K views
    Prev 1 2 3 ... 372 373 Next
    WPS Academy
    Products
    Partners