How to clear formatting rules in Excel?
We can use conditional formatting to mark specific contents quickly. But how can we clear the format when we don’t need it? Here are the steps.1. Select the cells whose format you want to clear. 2. Click Home > Conditional Formatting > Clear Rules.3. Then we can select Clear Rules from Selected Cells or Clear Rules from Entire Sheet according to actual needs. WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish ....
How to change the page orientation in Excel
To be office excel advanced, you could learn how to use WPS Office Spreadsheets online in WPS Academy.When we need to print, it happens that the table is display incompletely. At this time, we need to manually change the page orientation. 1. Head to the Home tab > Print Preview, where you can find this table is incompletely in one page because of its landscape orientation 2. To change its orientation, click Portrait, then the table is changed from the landscape to portrait orientation....
How to sort numbers in ascending or descending order in Excel?
When presenting and analysing data, you can use the sorting feature to place numbers in numerical order.Now let's explore the techniques together.1. Suppose we have a set of data already. Select the cells in the column you want to sort, and go to the Data tab. Then, click Sort > Ascending/Descending buttons. 2. In the pop-up dialog box, you can select Expand the selection to sort the data next to your selection as well or Continue with the current selection to sort the selected dat....
IFERROR Function in Excel
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. · Description:The IFERROR function returns an alternate value if the result is an error. · Syntax: IFERROR( value, value_if_error ) · Arguments:Value: The formula or value that you want to test.Value_if_error: Is any value or expression or reference if an error is found.(#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL) · Example:Assume that we want to....
DATEDIF function in EXCEL
· Description:Except for DAYS360 function(hyperlink), there is another more powerful function to calculate dates that are not in the same year. The DATEDIF function is mainly used to count the number of days, months or years between two dates.· Syntax:DATEDIF(start_date, end_date, comparison unit)· Arguments:Start_date: A serial date number that represents the start date.End_date: A serial date number that represents the end date.Comparison unit: The type of result you want to return.I....
The PROB 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.· Description:The PROB function calculates the probability that the values in a range are between two specific limits. · Syntax:PROB(x_range, prob_range, [lower_limit], [upper_limit]) · Arguments:X_range: Required. The range of numeric values associated with probabilities.Prob_range: Required. The array of probabilities ass....
Compare two excel files for differences in WPS Office Excel
Welcome to WPS Official Academy to check the contents of compare two excel files for differences in WPS Office Excel. We often need to compare the data from two different excel files, but it would be troublesome to compare each item one by one with naked eyes. So how can we compare two excel files for differences in a quick and easy way? Let’s have a try step by step. Here we take two tables of employees performance appraisal for example. We can find the two tables are inconsistent wit....
How to transpose columns to rows in Excel
1. Select the table area that needs to be transposed.2. Right-click, and choose Copy in the pop-up shortcut menu, or press Ctrl+C.3. Select a blank area where we want to paste the transposed table. Right-click, and place the cursor behind the Paste Special option in the pop-up shortcut menu. Finally, click Transpose.4. Then, we can transpose columns to rows in Excel, and vice versa. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.