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 » Naming Formula ranges
Naming Formula ranges
Resolved · Low Priority · Version 2003
Ryan has attended:
Excel Advanced course
Naming Formula ranges
How do you add give a formula range a name rather than the cell reference value?
RE: Naming Formula ranges
Hi Ryan
how are you doing today, thanks for your question
There are two ways you can name a range of cells, one is quicker than the other
Here goes 1. Go to the insert menu choose name, then click define, type the name and click add.
2. Click in the name box on the formula bar type the name for the range and press enter
NB: both the above ways essume cell are selected before you name ranges, and 2. make sure the names you call cells have no spaces as Excel won't except them...
Hope this helps
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
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:Change Excel's default fontYou can change the default font and font size for all spreadsheets created in Excel by: |