How to create and edit named ranges in Excel?

You can easily locate the cells or cell ranges and follow your spreadsheets with named ranges. Here are steps to create and edit named ranges.lTo create a named range1. Navigate to the Formulas tab and click on Name Manager, whose shortcut key is Ctrl+F3. In the pop-up box, click New to define a new named range. Then you can enter name for the range, set the scope (Workbook or Sheet), add comments and set the applied range of cells. For instance, enter Nov_Sales at Name and it refers t....

How to insert line graph in Word?

1. Open your word document, and click the Insert tab > Chart.2. In the pop-up dialog, click Line > Use. There is one template for common users. If you want to apply the more templates, please go Template Premium first. 3. Right click the chart and click Edit Data to enter an excel document. 4. Enter the data in the excel document as needed, or you can also paste a table into it.Note: Please pay attention to the heading row and column, which should correspond to the chart.5. Then go ba....

How to insert and remove headers/footers in PDFs?

WPS PDF helps quickly add and remove headers and footers to a PDF. Here are the steps.1. Open WPS PDF and click Open PDF under the Create PDF option. Browse the PDF in which you want to insert heades and footers in the pop-up box, select it and click Open. 2. Navigate to the Insert tab and click Header and Footer button. Then select Add Header and Footer. In the pop-up box, you can set the position, content, font, and margins of the header and footer. Note: the following two functions....

How to convert Word to PDF

· Option 1:1. Open the document to be converted.2. Click the Tools tab, and click the Export to PDF button.3. In the pop-up window, we can set the Export range, Save Path, Export Type as needed.4. After setup is complete, click Export to PDF button. Then we can convert Word to PDF. · Option 2: 1. Click Menu in the upper left corner, and click Save As. 2. In the pop-up window, we select PDF Format (*.pdf) in the File Type box.3. When the exporting PDF file is completed, we can click Ope....

How to count unique values in Excel

There is no single function can count unique values in WPS Spreadsheet now, so we try to make it in anther way. Here we take a simple table as an example. It is a table of consumption records in a canteen. To make it more clear, some duplicate records are highlighted in different colors. Each ID card number corresponds to only one employees. Employees can enjoy different dishes by multiple payments when having lunch. This table records the number of payments. Now we want to work out....

Add connection points to connectors in PowerPoint

To make the joint of a connector and a shape more clear, we can add connection points.1. Open your PowerPoint in WPS Office.2. Select the connector, and you can see four icons appear on the right of the shape. 3. Click the Shape Outline icon > Arrow Style. Then we can change its style to those with connection points as needed. We can also customize the connection points. 4. Double click the connector, and an Object Formatting pane pops up. 5. We can choose a desired size and shape for....

The NUMBERVALUE Function in Excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables and more fulfilling your needs perfectly.lDescription:The NUMBERVALUE Function can be used to convert numbers in text format which cannot be recognized into numeric values.lSyntax:NUMBERVALUE( text, [decimal_separator], [group_separator] )lArguments:text: Required. The text value you want to convert to number.decimal_separator: Optional. The character used as the ....

Greater than or equal to in Excel

We may need to compare values when analyzing data. There are three methods to meet different needs. Here we take a sales table as an example. We want to know whether the sales volume met the sales goal 150000.Option 1: To find out the targeted values.1. Input the formula =E2>=150000 and press the Enter key to obtain the result. 2. Drag the cell to fill the rest. If the sales volume is greater than or equal to 150000, the result is “TRUE”; otherwise it is “FALSE.” Option 2: To highligh....