Naming cells in Microsoft Excel


Using Range Names in Microsoft Excel will make it more efficient to navigate an Excel Workbook, but best of all use a Range Name in a function in place of the Cell References. There are 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.

The steps to creating a range name are: Select a range of cells, click in the Name box type the name and remember to press enter. If you have several range names to create you can create then in one hit. Select the cells – include the headings (rows and columns) then in the Formulas tab, Select Create from Selection. If the heading label starts with a number ie: 2017 Budget, Excel will add the underscore for your automatically.

Examples of a range name used in Functions like Vlookup and Sum.

If you are still struggling AZ Solutions Pty Ltd conducts customized Face to Face training in Sydney – Australia.

= Vlookup(A6,ProductList,2,False)

=Sum(TotalSales)

 

Excel-Training-Courses-Sydney

 

Picture4

Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service.
Visit website reviews

Related Topics

How to create basic formulas 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