2367 results for how to freeze a line in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2367 results for how to freeze a line in excel
How to set the line numbers in WPS Writer
01:56How 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....
How to create a K-line chart of stock data
02:51How 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....
How to create a Form in spreadsheet
01:26How 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. ....
How to create a scatter chart in WPS Spreadsheet
02:53How 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....
How to add a stamp in a PDF file
01:42How to add a stamp in a PDF file
We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....
How to draw a column chart in WPS Spreadsheet
01:46How 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....
How to insert shapes in a worksheet
01:20How 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....
How to insert a signature in a PDF file
02:16How 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....