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

        1901 results for how to unhide column a

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

        1901 results for how to unhide column a

        How to draw a column chart in WPS Spreadsheet

        How to draw a column chart in WPS Spreadsheet

        01:46

        How to draw a column chart in WPS Spreadsheet

        A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

        Spreadsheet 18.8K views
        How to set a worksheet in WPS Spreadsheet

        How to set a worksheet in WPS Spreadsheet

        03:53

        How to set a worksheet in WPS Spreadsheet

        The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

        Spreadsheet 20.5K views
        How to print a table

        How to print a table

        12:23

        How to print a table

        This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

        Spreadsheet 12.1K views
        How to group data in a spreadsheet

        How to group data in a spreadsheet

        02:01

        How to group data in a spreadsheet

        When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

        Spreadsheet 14.6K views
        How to create a Combination chart quickly

        How to create a Combination chart quickly

        03:43

        How to create a Combination chart quickly

        The Combination chart combines two or more types of charts in one coordinate system. We take this table as an example to explain how to make a Combination chart in WPS Spreadsheet. Here is the data of temperature and rainfall in a region. From this table, we can see three sets of data, namely, Rainfall, Mean Rainfall, and Temperature.We choose the cell range A1:D8, click the Insert tab, click Chart, and select Combo in the pop-up dialog.Gif At the top of the dialog, WPS Spreadsheet pro....

        Spreadsheet 9.4K views
        How to add a watermark

        How to add a watermark

        02:14

        How to add a watermark

        WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

        Writer 17.8K views
        How to insert shapes in a worksheet

        How to insert shapes in a worksheet

        01:20

        How to insert shapes in a worksheet

        We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

        Spreadsheet 12.5K views
        How to make a resume to impress picky HR

        How to make a resume to impress picky HR

        04:35

        How to make a resume to impress picky HR

        An amazing resume is a must-have for the employee who wants to stand out among job applications.Today we will learn how to create a resume in excel.First, set the page size.Head to the "Page Layout" tab and set the page as A4 at "Size." Then select the default "Narrow" at "Margins." Step two, decide where to arrange your texts.Before setting the area, click "Page Break Preview" in the lower right corner to change the view mode. So we can better understand the sector locations for the s....

        Spreadsheet 18.1K views
        Prev 1 2 3 ... 237 238 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