Modifying a Range Name in Microsoft Excel


Range Names are used to make navigating in Excel Spreadsheets more efficient as well as making functions easier to understand. If you have ever created a Range Name by selecting a range of cells and allocating a name for them, then if the selected data increases you may find that you need to update the existing Range Name. You can do this by going to the Formulas Tab and Selecting Name Manager then in the Refers to: Field modify the range and tick the box. Any formulas or function where the range name has been used will all now automatically be updated. Remember the rules about Naming Ranges: – No Spaces is the big point to make as most people forget. The Range Names must start with a letter, no symbols, you can use text and numbers, but it can’t be the name of a cell eg: You Can’t use QTR1 as this is a cell. The next big point that people forget is you must press ENTER otherwise you have not completed the steps and your Range Name will not work.

A Vlookup function is a great example of where you can use a Range Name. The structure for a Vlookup goes like this: =Vlookup(Lookup Value, Table, Column Number, False or True). Use a Range Name for the Table component of the Vlookup function.

=Vlookup(A6,ProductList,2,False)

Offering Customized Computer Training Courses in Sydney – Australia “We come to you”.

Servicing Our Customers since 1999 – Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service.

Free Tutorials | YouTube Channel – Analir Pisani

Visit website reviews

 

Excel-Training-Courses-Sydney

Excel-Training-Courses-Sydney

Related Topics

Naming cells in Excel

How to create a Vlookup function in Excel

Vlookup not working?

 

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s