| |
Office |
Version |
| Tool |
2007 |
2003 |
PRO |
Basic |
| Compare worksheets…(PRO) |
x |
x |
x |
|
| Counting analysis…(PRO) |
x |
x |
x |
|
| Generate a report…(PRO) |
x |
x |
x |
|
| Fill color in cells with same value |
x |
x |
x |
x |
| Fill color in cells with same value as active cell |
x |
x |
x |
x |
| Filter on the fly… |
x |
x |
x |
x |
| Header formula (SUM) |
x |
x |
x |
x |
| Header style |
x |
x |
x |
x |
| Filter active cell |
x |
x |
x |
x |
| Header formula (COUNT) |
x |
x |
x |
x |
| Show All |
x |
x |
x |
x |
| Outline |
x |
|
x |
x |
| Worksheet view... |
x |
x |
x |
x |
| Convert to values =value() |
x |
x |
x |
x |
| Copy-paste values in selection |
x |
x |
x |
x |
| Formula error message (is error)… |
x |
x |
x |
x |
| Fill color in each n'th row in selection... |
x |
x |
x |
x |
| Unhide rows or columns |
x |
x |
x |
x |
| Create an index page with links to all sheets |
x |
|
x |
x |
| Remove all empty worksheets |
x |
|
x |
x |
| Hide/Unhide Sheets Control… |
x |
|
x |
x |
| Remove unused empty ending rows and columns |
x |
|
x |
x |
| Count number of characters in active cell |
x |
x |
x |
x |
| Remove unnecessary spaces |
x |
x |
x |
x |
| Reverse text in selected cells |
x |
x |
x |
x |
| Extract text |
x |
x |
x |
x |
| Extract Numbers |
x |
x |
x |
x |
| Change values to text (add ') |
x |
|
x |
x |
| Add character before and after a value… |
x |
x |
x |
x |
| Rounding numbers… |
x |
x |
x |
x |
| Convert numbers to words…(PRO) |
x |
|
x |
|
| Customize number style… |
x |
x |
x |
x |
| Accounting style |
x |
x |
x |
x |
| Global date style dd-mmm-yyyy |
x |
x |
x |
x |
| Style 1 |
x |
x |
x |
x |
| Style 2 |
x |
x |
x |
x |
| Define a dynamic range… |
x |
x |
x |
x |
| Delete all range in entire workbook |
x |
x |
x |
x |
| Delete all range names in active worksheet |
x |
x |
x |
x |
| Remove empty rows in selection |
x |
x |
x |
x |
| Delete duplicate cells in selection |
x |
x |
x |
x |
| Remove identical rows |
x |
x |
x |
x |
| Remove hyperlinks, pictures and shapes… |
x |
x |
x |
x |
| Activate hyperlinks |
x |
x |
x |
x |
| Stock historical prices...(PRO) |
x |
|
x |
|
| Stock online price...(PRO) |
x |
|
x |
|
| Print multiple sheets at once... |
x |
|
x |
x |
| Insert details to the footer right page... |
x |
|
x |
x |
| Empty all details in header and footer |
x |
|
x |
x |
| Copy selection as JPG |
x |
x |
x |
x |
| Password recovery…(PRO) |
x |
x |
x |
|
