How to make a double slashes header in WPS Spreadsheet
1. Use WPS Office to open the spreadsheet, click the Insert tab and then click the Shapes button. Select a straight line from the drop-down menu. Then insert a straight line into the table. 2. Insert a straight line again.3. Click the drop-down button of Text Box in the Insert tab, and select the Horizontal Text Box.4. Then draw a text box at the designated position, and enter the needed text in the text box. We can adjust the text box according to our needs. If the content in the text....
How to get calculate average
· Option 1: with Quick AccessSelect the cell range filled with the data for calculation.Click Home from the toolbar → AutoSum dropdown button → choose Average · Option 2: with the AVERAGE functionEnter the formula =AVERAGE(Select the cell range filled with the data for calculation.Press Enter to get the average result. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.
Quick access to insert date and time into a sheet
lShortcut to insert the date: CTRL + semicolom(;)lShortcut to insert the time: CTRL + quotation mark(") WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.
How to shift among multiple spreadsheets
· Option 1: We can shift among different sheets with shortcut keys Ctrl + PageDown and Ctrl + PageUp on the keyboard.· Option 2: Click on the sheet tabs (e.g. sheet1, sheet2, sheet3) at the bottom of the interface to shift among different spreadsheets.WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.
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.
How to count cells by color in Spreadsheet?
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, we will highlight duplicate cells with custom colors to identify data easier. But how can we count them? In this tutorial, you will learn how to highlight duplicate cells by color.1. Open your table in WPS Spreadsheet.2. Click the Home tab, then select the Find and Replace button or use the shortcut key Ctrl+F. 3. In the pop-up dialog, click....
How to copy and paste the filtered table data？
1. Open your document and filter the data as needed. Here we take this sales table as an example. We want to know sales in Beijing and Shanghai. 2. Select the cells to be copied after filtering. Click Ctrl+C and click Ctrl+V to paste in the targeted area. WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.
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....