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....
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 combine first and last names
How can we merge different cells while keeping all contents inside? Follow these few steps.Suppose that we need to combine the contents in cell B3 and C3. 1. Enter =A3&B3 in cell D3.2. Then you’ll find the the first and last name combined in cell D3. However, we know that there should be a space between each first and last name. Can we realize it?1. Enter =A3&" "&B3 in cell D3. (Note that there should be a space within the pair of quotation marks, regarding the language habits of Engl....
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 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.
How to display hidden content?
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.1. Open your worksheet in WPS Office. 2. Select the columns you want to hide, then right-click and select Hide. In this case, we want to hide column C and column D.3. If you want to display hidden contents, select their adjacent columns, right-click, and select Unhide.
Present formulas as text in a sheet
1. Double-click the target cell.2. Insert a single quote (‘) at the beginning of the cell.3. Press Enter.As we can see, the complete formula presents in the original cell.To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to print the entire worksheet on one page?
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, it is annoyingly to find that a printed page is can only accommodate a few columns of data. Today we will learn how to print the entire worksheet on one page and it's easy to grasp.1. Open your worksheet in WPS spreadsheets.2. After clicking Print Review, we will find several columns of the table have disappeared. 3. To solve this, you c....