In standard Excel you can't set the height or with of cells in centimeters or inches. Creating square cells is also difficult because Excel uses different units for the width and height of cells.
Setting the width and height in centimeters or inches can be helpful if you use the Excel for drawing purposes, such as [...]

Posted on February 23rd, 2010 by Bastien
Filed under: ASAP Utilities, how to | 1 Comment »

At this moment ASAP Utilities already contains several tools to manage duplicates.
However a special tool for duplicate records was still missing... until now!
You could already identify or remove duplicated records with a workaround by merging the cell contents into a temporary added column and then use ASAP Utilities' "Conditional row and column select, hide or [...]

Posted on February 18th, 2010 by Bastien
Filed under: ASAP Utilities, how to | 1 Comment »

There are few quick methods to remove the line breaks and carriage returns in cells.
By default you might not know an easy and quick way to do this but it is fairly simple, either with just Excel, or with the help of ASAP Utilities.
Let's say we have the following example.
In this case the author has [...]

Posted on January 18th, 2010 by Bastien
Filed under: ASAP Utilities, how to | 3 Comments »

Last month I received the following question:
I need to know how to convert an excel file into a pipe delimited file using the ASAP software.
You can use the following tool to do this:
ASAP Utilities » Export » Export selection or active sheet as new file...
Then choose "CSV (comma separated value) or customer separated" and specify [...]

Posted on January 15th, 2010 by Bastien
Filed under: ASAP Utilities, how to | 3 Comments »

Last week I received the following question:
How we can spell check on all sheets. Can you add this in next version/update?
Well, you can already do this in Excel.
Just select all or multiple sheets and then when you start the Spelling (F7) the spelling check will take place on the selected sheets.

Posted on January 13th, 2010 by Bastien
Filed under: General, how to | Comments Off

I just received the following question which might be interesting the share with you. ASAP Utilities contains many tools and one of the strengths is that you can often use a combination of the tools to accomplish what you need.
The question I received this week:
I want to insert a blank row after every 3rd row [...]

Posted on December 31st, 2009 by Bastien
Filed under: ASAP Utilities, how to | Comments Off

Last week I received the following question:
Bastien,
First, thank you so much for the best Excel add-on ever!
Is there a way to remove empty rows in a only a selected section of the worksheet, not the whole worksheet?
Or have I missed this option that is already included?
Surely you can do this!
The utility "Columns & Rows » [...]

Posted on November 9th, 2009 by Bastien
Filed under: ASAP Utilities, how to | 1 Comment »

Last week I received the following question:
I get sent Excel files from various vendors. I have to convert these to SAS datasets that get moved to a UNIX system. The SAS datasets can only contain ASCII 32-127. So I need to remove these from the Excel file.
You can use the "Text » Advanced character remove [...]

Posted on August 13th, 2009 by Bastien
Filed under: General, how to | 3 Comments »

Last week I received the following question:
Is there an ASAP Utilities function that can remove all negative numbers from a spreadsheet? I haven't found it yet.
Yes there is. You can use ASAP Utilities to help you to quickly delete negative numbers.

You can use the following tool to select all cells with negative numbers (values [...]

Posted on August 3rd, 2009 by Bastien
Filed under: ASAP Utilities, how to | 17 Comments »

I just received the following question:
I will like to know how I can see the duplicates in a selection data? I'm aware I can delete duplicates, however I will like to know how to identify them first before deleted.
Here's how to do this:
You can use the following tool to select the cells with duplicated values:
[...]

Posted on July 29th, 2009 by Bastien
Filed under: ASAP Utilities, how to | Comments Off