98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Naming ranges
excel xp training - Naming ranges
Resolved · Low Priority · Version Standard
Erica has attended:
Excel Advanced course
Naming ranges
I am having difficulty replacing formulas with names. I have defined the name and they show in the box but when i go to apply the named range it says it can't find a reference. can you help?
RE: Naming ranges
I suggest creating a new formula, from scratch, using the actual range, and then using the apply command to see if you can get it to work.
Another step could be to check that the original formula contains exactly the same range as the named range.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |