This tip involves using naming cells. Among the many benefits, Defined Names can be used to:

quickly navigate large spreadsheets
easily define print areas
simplify formula entry
In the below table I want to easily reference the data in any given column or row. Since the data is in a table one can easily create a Defined Name, for each column and row, using the Create from Selection command.

свернуть