|
Category |
Feature |
BASIC |
PRO |
|
Compare |
Compare worksheets… |
|
x |
|
Data |
Counting analysis… |
|
x |
|
Data |
Generate a report… |
|
x |
|
Data |
Fill color in cells with same value |
|
x |
|
Data |
Fill color in cells with same value as active cell |
x |
x |
|
Table |
Filter on the fly… |
x |
x |
|
Table |
Header formula (SUM) |
x |
x |
|
Table |
Header style |
x |
x |
|
Table |
Filter active cell |
x |
x |
|
Table |
Header formula (COUNT) |
x |
x |
|
Table |
Show All |
x |
x |
|
Table |
Borders all |
x |
x |
|
Formula |
Convert to values =value() |
x |
x |
|
Formula |
Copy-paste values in selection |
x |
x |
|
Formula |
Formula error message (is error)… |
x |
x |
|
Sheets |
Fill color in each n'th row in selection... |
|
x |
|
Sheets |
Unhide rows or columns |
x |
x |
|
Sheets |
Create an index page with links to all sheets |
x |
x |
|
Sheets |
Remove all empty worksheets |
x |
x |
|
Sheets |
Hide/Unhide Sheets Control… |
x |
x |
|
Sheets |
Separate rows upon filed: grey & white |
x |
x |
|
Sheets |
Separate rows upon filed: lines |
|
x |
|
Text |
Count number of characters in activecell |
x |
x |
|
Text |
Remove unnecessary spaces |
x |
x |
|
Text |
Reverse text in selected cells |
x |
x |
|
Text |
Extract text |
x |
x |
|
Text |
Extract Numbers |
x |
x |
|
Text |
Change values to text (add ') |
x |
x |
|
Text |
Add character before and after a value… |
x |
x |
|
Text |
Customize text |
x |
x |
|
Number |
Rounding numbers… |
x |
x |
|
Number |
Convert numbers to words… |
x |
x |
|
Style |
Customize number style… |
x |
x |
|
Style |
Accounting style |
x |
x |
|
Style |
Global date style dd-mmm-yyyy |
x |
x |
|
Style |
x |
x |
|
Style |
Style 2 |
x |
x |
|
Range |
Define a dynamic range… |
x |
x |
|
Range |
Delete all range in entire workbook |
x |
x |
|
Range |
Delete all range names in active worksheet |
x |
x |
|
Range |
Remove empty rows in selection |
x |
x |
|
Range |
Delete duplicate cells in selection |
x |
x |
|
Range |
Remove identical rows |
x |
x |
|
Objects |
Remove hyperlinks, pictures and shapes… |
x |
x |
|
Objects |
Activate hyperlinks |
x |
x |
|
Professional |
Stock historical prices... |
|
x |
|
Professional |
Stock online price... |
|
x |
|
Printing |
Print multiple sheets at once... |
x |
x |
|
Printing |
Insert details to the footer right page... |
x |
x |
|
Printing |
Empty all details in header and footer |
x |
x |
|
Others |
Copy selection as JPG |
x |
x |
|
Others |
Password recovery… |
|
