The following video will show you how to sort the sheet-tabs in alphabetical order in Excel by using ASAP Utilities. The example in the video show a workbook with several sheets with city-names: In the Excel menu choose ASAP Utilities » Sheets » Sort all sheets in alphabetical order Then result will then look like: Note: This old video is no ...

The latest version of ASAP Utilities (pre-released today) will solve an issue that can appear when you have both Windows XP and Excel 2007 installed. "After installing the latest version of ASAP-Utilities after upgrading to Office 2007, I began to encounter a problem with Excel 2007 where, upon clicking on an Excel file to open, the ...

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. In this update have made a few small improvements and added a new worksheet function that make creating strong passwords easy: =ASAPRandomPassword(length, use_symbols)This new function will return a strong password which contains of  - both uppercase ...

The following video will demonstrate you how to delete leading, trailing and excessive spaces from cells (trim) in Excel by using ASAP Utilities. The example in the video shows an address list with too many spaces: Several street- and city names contain a space at the beginning and/or at the end. Furthermore in a few names there are ...

The following video will demonstrate you extract hyperlinks from cells in Excel by using ASAP Utilities. The example in the video show a list of websites that I copied from my links-page. There is no easy way in Excel itself to get the hyperlinks from the cells. That's why I built such a functionality into ASAP Utilities. First ...

The following video will demonstrate you how to sort by color in Excel by using ASAP Utilities. It is not possible to sort by color in Excel. However we find that many people use colors to "tag" certain cells that need to be processed later. The example in the video show a list of keywords such as my ...

The following video will demonstrate you how to remove (or trim) leading zeros from numbers within a range in Excel by using ASAP Utilities. This utility also works for numbers that are not recognized by Excel or are proceeded with an apostrophe (such as '2). You can usually recognize these numbers because they are left-aligned: The following video ...

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. I have also experienced some crazy things with customizing the ribbon (qat) and empty Excel dialogboxes due to dynamic labels (getLabel). I will write more about that in a separate post. New/improved Fill » Random numbering of ...

The following video will demonstrate you how to select the unique values within a range in Excel by using ASAP Utilities. The video demonstrates how to select the color names that appear only once in the list: Note: This old video is no longer available and will in 2021 be replaced with a new version in a modern ...