Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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

All times are GMT -7. The time now is 05:19 PM.


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