Create simple and intuitive mini charts

The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

WPS Spreadsheet basic editing

This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

How to protect a word document and restrict editing

When using WPS Writer, we can use the Restrict Editing function to protect the word document. [First] Restrict EditingFirst, get into the Review tab and click Restrict Editing to open the Restrict Editing dialog on the right. Here we check the option titled Limit formatting to a selection of style. Next, click Settings to pop up the dialog, where we can set format restrictions for the selected text. In this way, any format changes will not be allowed in this document, while the Format ....

How to add background to PDF files

When we are editing PDF documents, if the entire white layout is too simple, we can add a nice background. Let's learn the tips for beautifying PDF files with WPS Academy. Take this document as an example. Click the Insert tab, the Background drop-down menu, and then click Add Background. In the dialog box, we can add pure color background to the document, or customize the background image. Click Browse and select a suitable picture from the computer.In Surface, we can adjust the r....

How to use Name Manager

We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....

How to add gridlines and guides in WPS Presentation

When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....

Quickly create dynamic charts

We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....

Basic settings on footer and header

When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....