I am trying to name cells in a range on a table that I already have created so that when writing formulas off of these cells it makes for easy reference. However, when I go to the name box next to the formula bar and input the name that I want excel gives me the following error:

"you must enter a valid reference you want to go to, or type a valid name for the selection"

All I did was for a single cell type the name in the name bar.

Any help?