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

        1599 results for how to switch axis in excel spreadsheet

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

        1599 results for how to switch axis in excel spreadsheet

        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 9.3K views
        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 16.7K views
        How to set the cell alignment in WPS Spreadsheet

        How to set the cell alignment in WPS Spreadsheet

        02:31

        How to set the cell alignment in WPS Spreadsheet

        To ensure the beauty of the spreadsheet, sometimes we need to align the contents of it. How can we quickly set the alignment of the spreadsheet?This video could help to solve the problem of How to set the cell alignment in WPS Spreadsheet. There are several alignment shortcut buttons in the ribbon, which are commonly used in the workplace. Now let's demonstrate them one by one.Top Align: Align text to the top of the cell.Middle Align: Align text so that it is centered between the t....

        Spreadsheet 26.1K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 13.1K views
        How to create a scatter chart in WPS Spreadsheet

        How to create a scatter chart in WPS Spreadsheet

        02:53

        How to create a scatter chart in WPS Spreadsheet

        A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

        Spreadsheet 10.7K 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 13.1K views
        How to use the Selection Pane in WPS Spreadsheet

        How to use the Selection Pane in WPS Spreadsheet

        01:49

        How to use the Selection Pane in WPS Spreadsheet

        How can we select and edit multiple pictures, texts, and other objects in excel? Today, we will learn some tricks about the Selection Pane.Take this table as an example. You may open the Selection Pane using the methods listed below.The first method is to select Selection Pane from the Find and Replace drop-down menu in the Home tab. The second approach is to go to the Page Layout tab and look for Selection Pane. Or, you can go to the right-hand navigation bar and look for Selection Pa....

        Spreadsheet 10.9K views
        How to insert a text box in Spreadsheet

        How to insert a text box in Spreadsheet

        03:13

        How to insert a text box in Spreadsheet

        The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....

        Spreadsheet 16.2K views
        Prev 1 2 3 ... 199 200 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