logo ASAP Utilities

“The right tools increase efficiency!”

Excel with ASAP Utilities in it's menu

Version history

A history of the various updates and improvements throughout the years

Awards & Reviews

Read the awards & reviews from magazines, newsletters and radio shows.

Testimonials

See what our users are saying about ASAP Utilities

Receive our newsletter

Receive an email as soon as a new version of ASAP Utilities is released

Trusted daily by over 26,000 organizations

Our list of clients exceeds 26,000 organizations in more than 140 countries.

What's new on ASAP Utilities

We'll keep you updated about new releases of ASAP Utilities. If you want to receive an email as soon as a new version is released, then subscribe to our newsletter. The news is also available as an rss-feed

44 Practical Tricks to Save Hours in Excel with ASAP Utilities

Because 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.
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!

DevelopmentThe 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.


Read the rest of this story »

Now available: ASAP Utilities 5.1!

because it makes YOU rock in Excel!We're proud to officially announce the new version 5.1 of ASAP Utilities!

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


Many thanks to everyone who has contributed their feedback and tested the pre-release!

Free upgrade

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

How it makes YOU rock in Excel?

Almost every week, we write a new tip to show you how to benefit from the tools in ASAP Utilities.
You can find the latest and previous tips at:
blog/index.php/category/how-to/


How we help MSF/Doctors Without Borders

Who is MSF/Doctors Without Borders?

Doctors Without Borders-Holland / Artsen zonder Grenzen NederlandDoctors Without Borders/Médecins Sans Frontières (MSF) is an international, independent, medical humanitarian organization that delivers emergency aid to people affected by armed conflict, epidemics, healthcare exclusion and natural or man-made disasters.
MSF offers assistance to people based on need, irrespective of race, religion, gender or political affiliation.
Founded in Paris, France in 1971, MSF is a non-profit self-governed organization.
MSF was awarded the Nobel Peace Prize in 1999. www.msf.org

How does our company help MSF/Doctors Without Borders?

Helping MSF/Doctors Without Borders...


Pre-release version 5.1

A pre-release of the new version 5.1 is pre-release now available for download.

A few improvements have been made and at this moment there are a few known bugs in ASAP Utilities 5.0 which have been addressed and fixed in the new version 5.1.
51-Sort by value - ignore minus sign (-) in numbers example with result - 500px.png


« previous 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 next »



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us