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