You could look at the help topic for this ( I can find it by looking for About labels and names in formulas ). I prefer to name my ranges and use those names within formulas, and you don't have to switch on any special setting in your options to do that, whereas you have to tick the "Accept Labels In Formulas" option in the Calculation tab of the Excel options dialog to use labels.