List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007

A bit off-topic but because working with shortcuts is often so much faster. I believe that shortcuts are are preferred when it comes to speed/productivity and reducing the chances on RSI. Microsoft: List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007 http://support.microsoft.com/kb/290938 Just in case you weren't aware, we have a list of the shortcuts in ...

Soon to be released: version 4.2.9

Text » Replace accented characters (á, ë, ñ etc.)...

While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.8 that I've now fixed in version 4.2.9. More information and download of the pre-release: http://www.asap-utilities.com/faq-questions-answers-detail.php?m=195 This version will probably be officially released next Thursday.

When Excel doesn't recognize empty cells correctly

Enno asked me the following: "... When I value-copy ranges where the If-function was used with a return value of "" (empty string), the cells are not blank, hence ISBLANK() = FALSE. Could you add a feature to remove empty strings? ..." Well, you can do this already with ASAP Utilities, although you cannot find it in the description of ...

How to insert blank rows where the value changes

Insert a blank row where the value changes

I got the following question from Jonathan this week: ... Don't know if this can be done at the moment, perhaps you could advise... I have a range of cells and I want to select ALL the cells/rows in the selection where the value changes. I can select the first cell where the value changes using 'Select Cells' ...

Prepare a document before sending it to others

When you send your Excel workbook to other people, sometimes you want to protect or hide certain parts. For example the formulas you used or temporary data in hidden columns. You can do this by using Excel's worksheet protection, however you should know that this protection is easily broken and not very secure. A better method to use ...

Weird looping through cells in a range object

Below is something that I experienced a while ago and was beyond my logic. Setting a range and looping through all cells in it didn't work initially as expected. Sub WeirdCelLooping()      Dim rngCel                                       As Range      Dim rngSelection                                 As Range      Range("A1:G10").Select      ' Doesn't work correctly:      For Each rngCel In Selection.Columns(1)            ' both rngCel and the selection have now the same address            Debug.Print rngCel.Address & " ...

Unhide all columns and rows

A short macro that will unhide all columns and rows in order to make all data visible again. Might be useful in some cases. Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = False End Sub If you want more control on which rows and/or columns to unhide, you can also use this tool ...

Now available: ASAP Utilities 4.2.8

Delete all objects in selected worksheets

Yesterday the new version of ASAP Utilities was officially released. You can read the details in the newsletter or you can immediately proceed to the download page. Besides several bugfixes, these are two new things: Objects & Comments » Delete all objects on current worksheetThis utility can now be used on multiple worksheets and has been renamed ...

Keep leading and remove only the trailing spaces

Jeff recently asked: I really like your product but just came upon a capability it is missing: Delete trailing spaces (but keep all other spaces). I expect it would be simple enough to add; would you? I never expected anyone to need a tool to only remove the trailing spaces but he needs it on imported ...

Add trailing zeros

example-fill-ending-zeros.gif

Max asked the following: Can the "Fill > fill up with leading zero's" option under be made to work on leading or trailing zeros? For instance, if I have three numbers: 1 12 123 I would run the option to fill them with trailing zeros so they would look like: 1000 1200 1230 We want to normalize the numbers so they would all be ...