WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • zero show

    150 results for zero show

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

    150 results for zero show

    Show or hide editing marks

    Show or hide editing marks

    02:27

    Show or hide editing marks

    All users may need to show or hide editing marks to preview the editing effects or make the document look neater. Today we are going to learn about how to show or hide editing marks. · Show/Hide paragraph marksTake this document as an example. Every time we press the Enter key, a black Paragraph Mark appears, which is also called Hard Return. In general, it appears at the end of a paragraph, and its code is "^p" in a Word document.It doesn't affect printing but sometimes has a nega....

    Writer views
    Customize the formats to show data changes

    Customize the formats to show data changes

    01:28

    Customize the formats to show data changes

    Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

    Spreadsheet views
    The Rehearse Timings feature of Slide Show

    The Rehearse Timings feature of Slide Show

    01:21

    The Rehearse Timings feature of Slide Show

    It is very important to limit the length of your speech in some speech contests or formal speech occasions. WPS Presentation provides the Rehearse Timings feature for us to rehearse the speech. Take this slide as an example. 1. Head to the Slide Show tab, and click the Rehearse Timings button to enter the rehearse mode. In the upper left corner, there is a timer that can be moved freely. 2. Click the inverted triangle icon on the left or click to jump to the next slide, and then the sl....

    Presentation views
    Use slash header to show the title name

    Use slash header to show the title name

    01:25

    Use slash header to show the title name

    Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

    Spreadsheet views

    How to hide zero(s) in a worksheet

    1. Click Menu at the upper-left corner → Options2. Get into the View tab in the pop-up window.3. In the category of Window options, uncheck the Zero Values option4. Press Enter. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

    Spreadsheet 0.1013 views

    How to show slides automatically

    1. Use WPS Office to open the document.2. Click the Slide Show tab → the Set Up Show drop-down button → the Auto option.3. Click the Slide Show from Current button. Then, all the slides will play automatically. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.

    Presentation views
    How to set up a slideshow in WPS Presentation

    How to set up a slideshow in WPS Presentation

    01:47

    How to set up a slideshow in WPS Presentation

    Before we preview or make a presentation with slides, we should set up the slideshow in advance. So, how are we going to set it? Take these slides as an example. We first need to click the Slide Show tab at the top and then click the Set Up Show drop-down button. Here, we can set the slideshow as Manual or Auto.If we want to customize the slideshow settings, click the Set Up Show button. In the popup Set Up Show dialog box, we can also set the show type, multiple monitors, etc... In Sh....

    Presentation 0.2343 views
    Custom cell formats

    Custom cell formats

    03:48

    Custom cell formats

    When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

    Spreadsheet views
    Prev 123...1819 Next
    WPS Academy
    Products
    Partners