Name Range in Excel
How to Name Range in Excel:
It’s been long time, I did not post any Article. So today I thought of writing one Article on one of the most useful features in Excel. I am talking about the Ability to Provide meaningful name for various items or Cell Range.
You can name any Cells, Ranges, Columns, Rows and other Objects. After naming them you can refer them by that Name any where in the workbook. It is very useful ability provided in Excel.
Here in this Article I am going to show you how to Name a Range in Excel. Follow the below Steps to Name a Cells Range:
Step 1. Select the Range in the workbook which you want to name it.
Step 2. To make the Named Range, Select the Range
Step 3. Press Ctrl+F3
Step 4. Click on “New Button” in the Name Manager Dialog Box.
Step 5. Give a Name and Select the Scope
Step 6. Click OK
Step 7. Click Close.
Step 8. Now Ranged Name is created.
Step 9. Now You can use this Range anywhere. To see the Example Click on this Link.
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON'T MISS ANY NEW ARTICLE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-Box