 <p>You can <code>effectively</code> name ranges using the text box in the top left of the screen (where appears the "B2" or whatever coordinate the cell has). Select entire column and insert the name there.</p> <p>Then the name is valid to use in formulas.</p>