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