There are some rules to follow while creating names. Now you can refer to it by just typing its name. To define a name to a range you can use shortcut CTRL + F3. In a nutshell, Named range is just naming of ranges. Now you can use “Target” to refer at A1 instead of writing B1. For example if you have a cell say B1, containing everyday targets, you can name that cell as specifically “Target”.
Well, named ranges are nothing but some excel ranges that are given some meaningful name. In this article we will learn about Named Range in Excel and will explore each and every aspect of it. I have mentioned it many times in my articles. Maybe from a friend, colleague or some online tutorial. While working on Excel, you’ve must have heard about named ranges in excel. In this article, we will learn How to create a Table and name the table in Excel.
