ADDRESS, ROW, and COLUMN functions

- [Voiceover] Excel has three functions related to…cell location: Address, Row, and Column.…And they're unusual, and you probably…won't need them very often, but occasionally…they can come in handy.…I'm looking at this list here, I certainly could…sort the list by Comp., but I want to keep it…in the current order.…I'm curious as to what the highest compensation amount is,…so I'll simply type, for example, in cell K2, =max,…meaning maximum or highest value, and rather than…highlighting the cells in column H, I'll simply…click column H and Enter.…And by the way, if you click column H, probably you're…seeing the same number down on the status bar,…provided you have these entries available.…

If you don't, you can right-click in in the status bar…and make sure these entries right here are checked.…You may not always want to keep these checked.…It just depends upon what you're interested in and…how you're using the status bar.…Nevertheless, when you highlight data,…and that includes clicking a column,…you're likely to see that entry down there.…