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 [...]

Posted on February 23rd, 2010 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities | 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, [...]

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

Many people have asked me the past years if ASAP Utilities has an option to split a table into several sheets. Either per so many rows, or by value. Until recently that wasn't possible, but now it is!. In cooperation with several users we have created a new utility. In the new version of ASAP [...]

Posted on February 11th, 2010 by Bastien
Filed under: ASAP Utilities | 5 Comments »