David Underwood’s Professional Blog

If you Excel spreadsheet will not wrap text more than likely someone has either set a row height on your row or used auto-formatting.

If you want to maintain the ability to word-wrap when using auto-formatting you needto set some options when initially setting the auto-formatting.

To set Auto-Formatting this way:

1. Click Format
2. Click Auto Format…
3. Choose a formatting style and click the “Options” button
4. Uncheck “Width/Height” to keep row heights where they are and to maintain the abilityto word-wrap
5. Click OK

If by chance someone before you set the formatting you can always clear it. This includesclearing row heights. Select either the area you wish to change or CTRL-A the entiredocument. Then click “Edit” then “Clear” then “Formats.” This will reset the formattingto defaults.

I thought you all might find this useful if you don’t already have a function to doit. This displays in a cell the most frequent text in an array. I found this in anonline newsgroup so I cannot take credit.

 The following is an array, so be sure to press Ctrl+Shift+Enter afterentering/pasting it into the formula bar:

=INDEX(A2:A12,MODE(IF(A2:A12<>0,MATCH(A2:A12,A2:A12,0))))

 Replace the red withthe array of your choice

In working with a spreadsheet today I needed a quick way to remove all hyperlinksfrom cells. There is no option for this in Excel. Instead I found a Macro online thatwill do this for you:

Sub DeleteHyper()
    ActiveSheet.Hyperlinks.Delete
End Sub

This has been tested by me and it doeswork.

Source:http://exceltips.vitalnews.com/Pages/T0117_Getting_Rid_of_All_Hyperlinks.html