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

        2317 results for how to freeze a line in excel

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

        2317 results for how to freeze a line in excel

        How to set the line numbers in WPS Writer

        How to set the line numbers in WPS Writer

        01:56

        How to set the line numbers in WPS Writer

        The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

        Writer 17.5K views
        How to create a K-line chart of stock data

        How to create a K-line chart of stock data

        02:51

        How to create a K-line chart of stock data

        The K-line chart also called the candlestick chart, consists of four elements: close price, open price, high price, and low price, mainly used to display stock, futures, and other transaction data in the financial field. Take this AMZN Stock as an example. Here is the stock data within a month, and we need to create a K-line chart with this data. 1. Select the cell range A2:E24, which contains the four elements: close price, open price, high price, and low price. If you select more cel....

        Spreadsheet 13.4K 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 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 14.4K 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 12.0K 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 18.8K views
        How to add a cover page in WPS Writer

        How to add a cover page in WPS Writer

        00:47

        How to add a cover page in WPS Writer

        WPS Writer is a terrific tool for adding a cover to your resume or report if you want them to have a great impression on others. How can we add a cover page to a document?We can turn to Cover Pages in the Section tab or click Cover Pages in the Insert tab. Click the Cover Pages button in the drop-down list, and we can see that there are different kinds of covers to choose from, including Business, Resume, Thesis and Transverse. After selecting the cover page, we can change the build-i....

        Writer 17.9K views
        How to insert a signature in a PDF file

        How to insert a signature in a PDF file

        02:16

        How to insert a signature in a PDF file

        We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....

        PDF 30.8K views
        Prev 1 2 3 ... 289 290 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