| On this page: Download | Upgrade | Buy |
Screenshot | View help file |
This popular and powerful add-in gives you many more tools with which to manipulate and analyse data in Microsoft® Excel® software.
- Find almost any selection of cells on a sheet (by their appearance, contents or location), and carry out some selected function on them, such as change the appearance, the contents or the location
- Work easily with duplicates, links, errors, colours, formats, hyperlinks etc etc
- Convert numbers or formulae easily
- Tidy up text and convert numbers which have been input as text (aren’t they annoying?!!!)
- Find missing items from lists of data
- Line up and compare two sets of data next to each other on one worksheet
- Add a clickable index page to your workbook
- Convert digits into words
- Swap instantly a block of data with the block adjacent (instead of having to insert, cut and paste and delete)
- PLUS much, much more ...
Click to see full size screenshot
In addition it takes just one click to
- see instantly the sum, average, sum of positives and negatives separately (useful for accountants to see Debits & Credits), maximum and minimum values of your selected area even if it contains error cells.
- see instantly an analysis of your selected cells in terms of the number of cells, and the number that contain formulae, values, positive values, negative values, zeros, errors, text, blank and non-blank cells.
The reason this is so useful is that (unlike the bar at the bottom of the normal screen) it shows you all the figures in one go, and it copes with error cells (see how the normal bar changes as soon as you shade over an error cell?).
By installing and using this software you affirm your complete and unreserved acceptance of the PATools
End User License Agreement
For new users, the software will run on an evaluation basis, which means that you can use it for as long as you wish but only run the main tools 30 times.
You can purchase a license 24/7 using our secure automated service from this webpage below.
Changes since last release
Upgrade
No need to uninstall your current version - simply close Excel, download as above and overwrite your existing copy.
If you have a licensed copy then you should download into the same folder as the previous version, otherwise you may need to re-enter your licensing details and may lose any saved settings.
Contact us if you have problems.
Buy
BUY NOW from the secure ordering site of our payment partner share-it! where you can pay in various currencies
Licenses expire after 1 year.
SAVE MONEY by buying an extended license (lasting more than 1 year) - see here
SAVE MONEY by buying several PATools Excel products - see here