Tip: Insert multiple rows at once

tip_insert_multiple_rows_by_hand.gif

Inserting multiple rows "the Excel way" If you want to insert multiple rows at once the standard procedure is to first select multiple rows and then use the "Insert" command. For example if you want to insert 10 rows between A1 and A2, you first have to select rows 2:11 and then insert the rows. Inserting multiple rows ...

ASAP Utilities newsletter

Last week I have sent out the ASAP Utilities newletter with information about the two new versions: ASAP Utilities released its new versions 4.0.5 and 3.10E! www.asap-utilities.com/asap-utilities-newsletter-2006-11.php More information about our mailinglist: www.asap-utilities.com/asap-utilities-mailinglist.php

New version in progress: November 3, 2006

The new version is completed for about 99%. The RC in the version stands for Release Candidate. I would like to thank everybody that emailed me the past couple of weeks! You can download 4.0.5 RC4, November 3, 2006: ASAPUtilities_setup_4-0-5-RC4.exe (1.1 MB) Major reason for this release are a few bugfixes. I will release this version officially probably ...

New version in progress: October 17, 2006

The new version of ASAP Utilities is still in progress. A few things took more time than I expected and I took the opportunity to add a few worksheet functions and a new utility. You can download 4.0.5 RC3, October 17, 2006: ASAPUtilities_setup_4-0-5-RC3.exe (1.1 MB) Please read the updated post from November 3, 2006 Major reason for this release ...

New version in progress: October 6, 2006

A new version of ASAP Utilities is in progress. You can download 4.0.5 RC2, October 6, 2006: ASAPUtilities_setup_4-0-5-RC2.exe (1.1 MB) Please read the updated post from October 17, 2006 Major reason for this release are a few bugfixes. Depending on the feedback I will release this version officially within a couple of days. I have also code-signed this version of ASAP ...

New version in progress: October 4, 2006

A new version of ASAP Utilities is in progress. You can download 4.0.5 RC1, October 4, 2006: ASAPUtilities_setup_4-0-5-RC1.exe (1.1 MB) Please read the updated post from October 6, 2006 Major reason for this release are a few bugfixes. Depending on the feedback I will release this version officially within a couple of days. Improved General Excel XP/2002/2003: Improved information on how to ...

Color a cell by just clicking on it

make a cell red when you double-click on it, and when you double-click on it again the red color is removed

Last week I got a question from Amit: I use the asap utilities a lot and it is great help. My question is regarding cell coloring. I'd like to be able to assign only two colors to a cell. For example, say if you select a cell once (or click on it once), it turns Red. ...

Screenshots of the different Excel versions

I have always wondered how Excel looks in other countries. In my office we use both the international and the Dutch version(s) of Excel. Today I have created a new page on the main website displaying screenshots of the various Excel versions in different countries. At this moment only international and Dutch ranging from Excel 97 ...

New version: September 20, 2006

A new version of ASAP Utilities is just released. You can download 4.0.4, September 20, 2006 from the main website: www.asap-utilities.com/download-asap-utilities.php Major reason for this release are a few bugfixes. Thank you all for the feedback on the preview version. Improved utilities Delete leading and trailing spaces Cells with (array)formulas and errors will be skipped. Delete leading, trailing and excessive spaces Cells ...

New version in progress: September 19, 2006

A new version of ASAP Utilities is in progress. You can download 4.0.4 preview, September 19, 2006: ASAPUtilities_setup_4-0-4-preview.exe (1.1 MB) Depending on the feedback I will release this version officially withing a couple of days. Major reason for this release are a few bugfixes. Improved Delete leading and trailing spaces Cells with (array)formulas and errors will be skipped. Delete leading, ...