September 15, 2014

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:
http://www.asap-utilities.com/blog/index.php/category/how-to/
http://www.asap-utilities.com/asap-excel-tutorial-how-to.php
http://www.facebook.com/ASAPUtilities

---

February 19, 2014

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.

Read the rest of this story »

---

January 28, 2014

Now available: ASAP Utilities 5.1!

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.

• Download ASAP Utilities 5.1
• View the changes.

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:
http://www.asap-utilities.com/blog/index.php/category/how-to/

---

September 13, 2013

How we help MSF/Doctors Without Borders

Who is MSF/Doctors Without Borders?

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

---

June 18, 2013

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.

Stay informed about new releases

Subscribe to our newsletter (in English) and we'll notify you when a new version or important update is released.