What's new on ASAP Utilities

Now available: ASAP Utilities 5.6!

We're proud to officially announce the new version of ASAP Utilities!
The past year we have worked, in cooperation with many of our clients, on the new version of ASAP Utilities.

Several improvements have been made to help you save time in Excel.

• Download ASAP Utilities 5.6
• See what's new

To upgrade, just install the new version 'on top' of the current version on your computer.

Free upgrade

All our clients get version 5.6 free of charge!
Your existing 4.x and 5.x license will also work with the new version 5.6

How it makes YOU rock in Excel?

These short tutorials are guaranteed to save you time and speed up your work in Excel. Enjoy!
incredible-tricks-to-save-hours.php

Milestones reached in 2015

• ASAP Utilities helped its users to save 10 Million hours together this year!
  On average ASAP Utilities saves people 29.5 hours each year (measured among 73,932 users in October 2015).
  With an estimate of 350,000 users in total, this makes a total savings of over 10 Million hours all together saved while working in Excel. Each and every year.
• Our list of clients grew to over 13,500 organizations in over 140 countries.
  
• Our Facebook page is now liked by more than 300,000 people from around the world!
  Yes, that is Three Hundred Thousand fans! We're very proud! ASAP Utilities continues to grow and improve thanks to your support, your suggestions and your encouragement and shared enthusiasm.

Now available: ASAP Utilities 5.5.1!

The new version of ASAP Utilities has just been released!
We've made a few important changes in this new version of ASAP Utilities and recommend everybody to upgrade to version 5.5.1.
Compare to version 5.5 from last week, 5.5.1 has got a few enhancements and the setup is updated to match a Microsoft security update.

• Download ASAP Utilities 5.5.1
• See what's new

To upgrade, just install the new version 'on top' of the current version on your computer.

Free upgrade

All our clients get version 5.5 free of charge!
Your existing 4.x and 5.x license will also work with the new version 5.5.

How it makes YOU rock in Excel?

Frequently we write a new tip on our website to show you how to benefit from the tools in ASAP Utilities.
You can find the latest and previous tips at:
incredible-tricks-to-save-hours.php

Thank you for your feedback the past 15(!) years

Our thanks go out to each and every one of you for your feedback.
ASAP Utilities continues to grow and improve thanks to your support, suggestions and encouragement.

Now available: ASAP Utilities 5.5!

We're proud to officially announce the new version 5.5 of ASAP Utilities!

Many improvements have been made to help you save time in Excel.

• Download ASAP Utilities 5.5
• See what's new

To upgrade, just install the new version 'on top' of the current version on your computer.

Free upgrade

All our clients get version 5.5 free of charge!
Your existing 4.x and 5.x license will also work with the new version 5.5.

How it makes YOU rock in Excel?

Frequently we write a new tip on our website to show you how to benefit from the tools in ASAP Utilities.
You can find the latest and previous tips at:
incredible-tricks-to-save-hours.php

Thank you for your feedback the past 15(!) years

Our thanks go out to each and every one of you for your feedback.
ASAP Utilities continues to grow and improve thanks to your support, suggestions and encouragement.

44 Practical Tricks to Save Hours in Excel with ASAP Utilities

Frequently we write a new tip on our website to show you how to benefit from the tools in ASAP Utilities.
These short tutorials are guaranteed to save you time and speed up your work in Excel. Enjoy!

1. Tip: Quickly perform a calculation on all selected cells at once
2. Tip: Quickly deselect cells from a selected range
3. Tip: Get rid of unwanted spaces in your data
4. Tip: Quickly add a prefix or suffix to your data
5. Tip: Select cells automatically based on their contents, formatting, etc.
6. Tip: Quickly change the text-case in all selected cells at once
7. Tip: Quickly (un)protect all sheets at once
8. Tip: Save and create a time stamped backup
9. Tip: Insert a border or blank row after repeating cell values in a column
10. Tip: Save Chart or Range as picture (JPG, PNG, vector etc.)
11. Tip: Save time with keyboard shortcuts
12. Tip: Quickly sort your sheets by their value or tab-color
13. Tip: Quickly insert multiple sheets at once
14. Tip: Quickly edit or export cell comments
15. Tip: Quickly make numbers positive or negative
16. Tip: Quickly extend your selection down to the end without scrolling
17. Tip: Quickly toggle Full Screen with the F11 key
18. Tip: Quickly remove blank rows from a long list
19. Tip: Easily strip leading zeros from your numbers
20. Tip: 'AutoFit Row Height' on merged cells too
21. Tip: Quickly fill blank cells with value above in Excel
22. Tip: Easily remove certain or several characters at once
23. Tip: Fast calculation on selected cells
24. Tip: Easily remove leading characters
25. Tip: Quickly save worksheets as separate files
26. Tip: Easily count and/or color duplicate values
27. Tip: Sort your data on anything that you can think of
28. Tip: Quickly close multiple workbooks at once
29. Tip: Quickly copy page layout settings from one sheet to other sheets
30. Tip: Quickly re-start the last used tool
31. Tip: Test your model/template in different screen resolutions
32. Tip: Quickly find the tool you need
33. Tip: Easily change the text in selected cells to UPPERCASE
34. Tip: Easily insert an English formula in your non-English Excel version
35. Tip: Easily transpose 1 column into multiple rows, creating a table
36. Tip: Quickly select or filter by strikethrough formatted text
37. Tip: Easily keep only the filtered results
38. Tip: Quickly fix the trailing minus sign for negative numbers
39. Tip: Easy ways to combine the contents of multiple cells
40. Tip: Auto numbering on steroids
41. Tip: Quickly reset the last cell and minimize the used range
42. Tip: Quickly round the numbers in selected cells
43. Tip: Easily COUNT or SUM cells based on their Color
44. Tip: Quickly remove spaces from the beginning and end of your data

You can also find the latest and previous tips and get updated at:
blog/index.php/category/how-to/
asap-excel-tutorial-how-to.php
http://www.facebook.com/ASAPUtilities

Now available: ASAP Utilities 5.2.1!

The new version of ASAP Utilities has just been released!

A few improvements have been made but the most important reason to release this so quickly after version 5.1 is because we fixed a bug that was introduced in 5.1 and prevented sometimes the start of ASAP Utilities in Excel 2007, 2010 or 2013 versions that are not English, Spanish, French, German or Dutch.