![]() |
|
#1
|
|||
|
|||
|
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? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Can I pre-populate cells with a formula?
|
Box | Excel | 1 | 05-03-2014 11:55 PM |
Formula works on most cells
|
gbaker | Excel | 1 | 04-26-2014 12:31 AM |
| Copying a formula that uses pivottable cells | Paul46 | Excel | 0 | 02-08-2014 07:04 AM |
| Referencing a value over 255 characters within a table PLUS strange formula behaviour | TishyMouse | Excel | 2 | 01-08-2013 09:39 AM |
| Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |