Skip to content
Archive of entries posted on

Create a dynamic range reference

One of the most common issues that arise in Excel is that a range that contains data will eventually expand as more data are added or even contract as data are removed. If we have a formula, or an Excel functionality (such as Data Validation or a PivotTable), or a chart, that refers to such […]

TM Excel Dynamic Path Navigator

One of the features that consumers may find useful is retracing their path as they navigate through different workbooks, different sheets, and different windows. This navigation would be equivalent of a web browser’s Previous and Next feature. While Excel does not support this natively, the code in this note enables this capability. For a version […]

Create a header cell with text separated by a diagonal line

In creating a table header that explains what the row and column values represent, a common approach is to use a cell with text separated by a diagonal line. This, first for me, video tutorial explains how. For those who prefer a text explanation: Format the cell “border” to add a diagonal from the left-top […]