How to erase cell borders in a worksheet

Click Home → the Draw Border icon → choose Erase Border When the curse presents as an Eraser tool, left-click on the border that you would like to erase. You can also drag the Eraser tool to clear borders for cells within a range. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

How to set drop cap?

1. Open the document in WPS Writer, and select the paragraph you want to set.2. Click Insert → Drop Cap. 3. Select the position and set the options as needed. Click OK.Tips: You can’t set drop cap when the first character is a blank space, tab character or paragraph mark. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

How to select multiple cells in contiguous range

In WPS Spreadsheet, we can select an entire cell range with a shortcut key until the empty cell. Here are the steps. 1. Select a cell in WPS Spreadsheet.2. Press the shortcut key Ctrl+Shift+↓on the keyboard.To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

Highlight cells greater than a specific value

It will format cells filled with a value greater than a specific number. In the following example, Conditional Formatting helps us highlight cells greater than $700,000.1. Select an array for conditional formatting.2. Go to the Home tab → click Conditional Formatting. 3. Choose Highlight Cells Rules → choose Greater than option from the drop-down menu.4. Enter '700,000' in the Greater than input box. Choose a format from the drop-down menu.5. Click OK. The cells greater than 70....

How to set the line spacing to a fixed value in WPS Writer

1. Use WPS Office to open the document and select the paragraph that we want to edit.2. Click the right mouse button and select Paragraph from the shortcut menu.3. In the pop-up Paragraph dialog, choose Indents and Spacing. In the Spacing area, choose Exactly in the Line spacing box. And in the At box, we can input a fixed value. For example, we input “40” pt here.4. Click the OK button. To be office word advanced, you could learn how to use WPS Office Writer online in WPS Academy.

How to create a custom path animation

1. Select the object for operation.2. Click the Animation → dropdown menu for animation effects.3. Choose a path type in the category of Draw Custom Path.4. Draw the custom path within the slide with the mouse. Thousands of free WPS Presentation templates are waiting for you, just in WPS Office.

Conditional Formatting for data visualization

The Conditional Formatting function can format cells fulfiling specific conditions. We can visualizate data with this function.1. Select an array for conditional formatting.2. Go to the Home tab → click Conditional Formatting.3. Choosing the Manage Rule... option to pop up the Conditional Formatting Rules Manager dialog.Customize (Manage) Rules for Conditional Formatting4. Click New Rule to pop up the New Formatting Rule dialog, where you can access settings of conditions and cell form....

How to adjust the audio volume in WPS Presentation

· Option 11. Open the file in WPS Presentation.2. Click the audio icon in our slide. Then we directly adjust the audio volume by dragging the volume bar below. · Option 21. Open the file in WPS Presentation.2. Click the audio icon in our slide. Then click the Volume drop-down button the functional area. Here, we can select the Volume as High, Medium, Low or Mute in the drop-down menu. This skill could be compatible with Microsoft Office PowerPoint.