#1
|
|||
|
|||
Naming Cells for formula referencing
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? |
#2
|
|||
|
|||
Hi
Difficult to tell, I never got this message. What name intended you to use? Maybe the name does already exist? Remember there are certain names you can't use, because excel itself uses them. For example you can't name cell A1 like ABC1, because ABC1 refers yet to a cell. But in this case, your error won't come up, rather it will jump to the entered name (address). |
#3
|
|||
|
|||
the cell is currently named "F3" I would like to name it "Total Fees"
this is odd, right? |
#4
|
|||
|
|||
Emtpy spaces aren't allowed, as well as some other signs. The first sign must be non-numeric.
You will have to do with something like this: TotalFees Total_Fees |
#5
|
|||
|
|||
AH HA!
Thanks! |
#6
|
|||
|
|||
How do I mark this as solved?
|
#7
|
|||
|
|||
On top of the thread it's shown various possibilities, the second left "Thread Tools" contains the option you're looking for
|
Thread Tools | |
Display Modes | |
|
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 |