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

        54 results for W W

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

        54 results for W W

        Must-have shortcut tricks in showing slides

        Must-have shortcut tricks in showing slides

        01:47

        Must-have shortcut tricks in showing slides

        When showing slides in WPS Presentation, we can greatly improve the efficiency with some shortcut tricks. lQuickly show slidesWhen there are multiple slides, and we want to start from the first slide, it's troublesome to find the first slide and click to show. At this time, we can use the shortcut key F5 to quickly realize the operation. For example, now we come to the seventh slide, and you can press F5 to jump back to the first slide. To directly start from the current slide, use....

        Presentation 8.1K views
        Four View Modes in WPS Writer

        Four View Modes in WPS Writer

        02:26

        Four View Modes in WPS Writer

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. We can choose different view modes according to the needs of our daily file reading. Take this document as an example. I will demonstrate four view modes of text. First, click the View tab. 1.Full Screenl If we only want to display the editing area, click Full Screen or use the shortcut Ctrl+Alt+F.l The document will be displayed on full screen,....

        Writer 17.5K views
        How to add and set the numbering in WPS Presentation

        How to add and set the numbering in WPS Presentation

        00:55

        How to add and set the numbering in WPS Presentation

        WPS Office is a comprehensive office suite that includes writer, spreadsheet, presentation and PDF editor all within one single software.When using WPS presentation, we may want to add numbering to make our slides look more organized. So, how can we add numbering?Select the text content that needs to be added with numbering, click the Home tab above, and then click the Numbering button. Here, we can see a variety of preset numbering provided by WPS. Click to select a style to add. If w....

        Presentation 23.4K views
        Use pivot chart to create a dynamic chart

        Use pivot chart to create a dynamic chart

        04:49

        Use pivot chart to create a dynamic chart

        A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....

        Spreadsheet 13.7K views

        Common shortcut keys in WPS Spreadsheet

        New File Ctrl + NClose the window Ctrl + WOpen…Ctrl + OSave Ctrl + SPrint Ctrl + PUndo Ctrl + ZRedo Ctrl + YCopy Ctrl + CCut Ctrl + XPasteCtrl + VFindCtrl + FReplaceCtrl + HGo To…Ctrl + GSelection PaneCtrl + F1Go to the beginning of the cellCtrl + HomeGo to the end of the cellCtrl + EndCreate a new line within a cellAlt + EnterExpand selection to the beginning of the cellShift HomePopup menu (right-click menu)Shift + F10 Help center F1Start to edit the cellF2Spell check F7Recalculate w....

        xls Spreadsheet 15.7K views

        How to make Excel Defined name in Excel file

        In everyday life, names are widely used to refer to people, objects, and geographical locations. For example, instead of saying "the city lying at latitude 40.7128° N and longitude 74.0059° W, you simply say "New York City". In Excel, you can create and use two types of names: Defined name - a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it's called a named range, or defined range. How t....

        xls Spreadsheet 6.3K views

        How to replace "space” with "paragraph mark”

        Find and Replace can help us to correct mistakes by quickly locating and replacing text. Also, we can search for and replace special characters, such as space and paragraph marks. Open your document with WPS Writer. Head to the Home tab and select the Find and Replace button > Replace, you can also use the shortcut key Ctrl+H. In the Find What box, enter the space bar on the keyboard, and type ^p, or select paragraph Mark from the drop-down list under the special button in the Replace ....

        doc Writer 10.2K views

        Guide to wrap text formula in excel

        Guide To Wrap Text Formula in Excel - WPS Academy The cells in the Excel spreadsheet are of a certain height and width. Although they can be adjusted, the wrap function is ideal when you have longer sentences and you want it to adjust vertically inside the cell. You may fully show lengthier text in a cell without it spilling over into other cells by using the Excel wrap text option. Displaying cell contents on many lines as opposed to one continuous line is known as "wrapping text." Ex....

        xls Spreadsheet 3.9K views
        Prev 1 2 3 ... 6 7 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