When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

Type the data. The entry appears in the first selected cell. Press "Ctrl-Enter" on the keyboard. Excel fills the other cells in the column with the same value.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.