Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2014, 06:54 AM
lynchbro lynchbro is offline Naming Cells for formula referencing Windows 8 Naming Cells for formula referencing Office 2010 64bit
Advanced Beginner
Naming Cells for formula referencing
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 06-26-2014, 07:05 AM
whatsup whatsup is offline Naming Cells for formula referencing Windows 7 64bit Naming Cells for formula referencing Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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).
Reply With Quote
  #3  
Old 06-26-2014, 07:23 AM
lynchbro lynchbro is offline Naming Cells for formula referencing Windows 8 Naming Cells for formula referencing Office 2010 64bit
Advanced Beginner
Naming Cells for formula referencing
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

the cell is currently named "F3" I would like to name it "Total Fees"
this is odd, right?
Reply With Quote
  #4  
Old 06-26-2014, 07:33 AM
whatsup whatsup is offline Naming Cells for formula referencing Windows 7 64bit Naming Cells for formula referencing Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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
Reply With Quote
  #5  
Old 06-26-2014, 07:34 AM
lynchbro lynchbro is offline Naming Cells for formula referencing Windows 8 Naming Cells for formula referencing Office 2010 64bit
Advanced Beginner
Naming Cells for formula referencing
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

AH HA!

Thanks!
Reply With Quote
  #6  
Old 06-26-2014, 07:34 AM
lynchbro lynchbro is offline Naming Cells for formula referencing Windows 8 Naming Cells for formula referencing Office 2010 64bit
Advanced Beginner
Naming Cells for formula referencing
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

How do I mark this as solved?
Reply With Quote
  #7  
Old 06-26-2014, 07:45 AM
whatsup whatsup is offline Naming Cells for formula referencing Windows 7 64bit Naming Cells for formula referencing Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

On top of the thread it's shown various possibilities, the second left "Thread Tools" contains the option you're looking for
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming Cells for formula referencing Can I pre-populate cells with a formula? Box Excel 1 05-03-2014 11:55 PM
Naming Cells for formula referencing 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft