Linking Chart Text Elements to a Cell

You can link the following chart text elements to a cell: – title – primary and secondary X-axis titles – primary and secondary Y-axis titles – series data label 1) Select one of the text labels 2) go to the Formula bar, type = (an equals sign), click a cell and press Enter. If you … Continue reading →

Excel: Replace empty fields with ‘0’

Problem: Within a certain cell range of numbers you want to replace empty fields with the number ‘0’. As you can search and replace empty cells you would have to fill them in manually. Really? Solution: 1) Type 0 in a single field and copy it. 2) Select the cell range where you want to … Continue reading →

Remove all Hyperlinks in an Excel Sheet

Create a module in VBA and simply paste in the following code: Sub DeleteHyper() ActiveSheet.Hyperlinks.Delete End Sub

Excel: Delta Function

Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. For example, by summing several DELTA functions you calculate the count of equal pairs. Example: DELTA(5, 4) checks whether 5 equals 4