Feedback appreciated This is our first video in a new series of tutorials. For accessibility and since many people view tutorials at work (with sound turned off), the video is with call-outs and subtitles. We are still experimenting with the right way to do this, so my apologies in advance in case the video tutorial looks a bit clumsy. Please let us know if you have any feedback that can help us. Video: How to quickly move and/or resize your… Read more... “Tip: Easily move and resize your range selection(s) in Excel (Video Tutorial)” The post Tip: Easily move and resize your range selection(s ..read more

The past week we have finally made a few important improvements to both our website and our blog. It is not finished yet, but already much improved. This blog has a new look and both our website and blog are now so called "responsive", which means that you can easier to view our site on devices such as your smartphone or tablet. I know, we should have done this many years ago already and the website and blog still need… Read more... “Small update to website and blog: responsive/mobile friendly” The post Small update to website and blog: responsive/mobile friendly first appeared on ASAP Utilit ..read more

Save 5 minutes a day by using ASAP Utilities to quickly export your data in a specific file-format. "Easily export your selected cells in a proper file format" Have you ever wondered why Excel cannot just export just your selected cells to a new file? Or why European users cannot simply create proper CSV files from Excel? In Excel, saving only your current selection as a new file can be a cumbersome process.Excel does have an "Only print the current… Read more... “Tip: Quickly save just your selection or sheet as a new file” The post Tip: Quickly save just your selection or sheet as a new fil ..read more

[last updated: March 4, 2021] Introduction The past years we have received several support requests that we found out were related to/caused by (often already fixed) bugs in Excel 2019/2016/365. This article shows information on how to update your Excel installation and also contains links to the Microsoft articles with all the detailed information about what has been fixed and improved by the Excel team. How an error or crash in Excel may appear to be caused by ASAP Utilities,… Read more... “The importance of Microsoft Office Update | Fix random crashes and performance issues” The post ..read more

Save 5 minutes a day by using ASAP Utilities to quickly clean up your data in Excel. "Easily optimize and clean your dataset" One of the first things you often need to do, when you import a file or copy information, is clean it up before you can analyse the data. There are many things that can be wrong, such as trailing spaces, unrecognized numbers, irregular formatting, hyperlinks, etc..Cleaning up your data helps makes sure that everything is correct, so… Read more... “Tip: Quickly clean up your data in Excel” The post Tip: Quickly clean up your data in Excel first appeared on ASAP Utilitie ..read more

Is Excel 2019 just Excel 2016 with a new name? Excel developers can use the command "Application.Version" to get the version of Excel. However, the new Excel 2019 returns the same version number as Excel 2016 (16.0). We expected Excel 2019 to return the number 17.0 (or 19.0) but certainly not 16.0. We recently purchased and installed the new Office 2019 in order to (successfully) test ASAP Utilities with it. To our surprise, we noticed that the new Excel 2019… Read more... “For developers; Application.Version returns 16.0 for both Excel 2019 and Excel 2016…!?” The post For developers; Applica ..read more

“Everyone can now install ASAP Utilities” One of the improvements in the new version 7.3 is that we have created a special version of the setup that can be installed by standard/limited users. We're currently still working on the new version but it's already available as a pre-release. By default only administrators and power users can install software on a computer. That also applied to ASAP Utilities. However, for users with Excel 2010 or later we now have a special… Read more... “By request: non-admin setup edition ASAP Utilities 7.3” The post By request: non-admin setup edition ASAP Utili ..read more

Save 5 minutes a day by using ASAP Utilities to quickly fix the numbers that Excel may not recognize. "Easily make Excel recognize the numbers in your selection" Sometimes Excel fails to recognize numbers properly, which causes unexpected results when you sort, filter, or use formulas. For example, when you import a file that was created in another program, such as an accounting package, downloaded from a mainframe or copied from a website, then Excel may fail to recognize the… Read more... “Tip: An easier way to fix the numbers that Excel doesn't recognize” The post Tip: An easier way to fix ..read more

Save 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. "Easily trim all leading and trailing spaces" Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or trailing spaces can cause unexpected results when you sort, filter, or use formulas. But it is easy to fix, just select the cells and use:… Read more... “Tip: Quickly remove spaces from the beginning and end of your data” The post Tip: Quickly ..read more

Save 5 minutes a day by using ASAP Utilities to quickly count or sum cells based on their background color. "Did you ever have to SUM by Color or Count by cell Color?" I have a column that needs summed, but only the cells that are green... Working with cell colors can help to make your Excel workbook easier to understand. Many people also use it to mark cells. Unfortunately Excel has no built in functions to use cell colors… Read more... “Tip: Easily COUNT or SUM cells based on their Color” The post Tip: Easily COUNT or SUM cells based on their Color first appeared on ASAP Utilities Blog ..read more