Naming cells in Excel


We create Range Names in Excel for cells that we might like to either:

Quickly Navigate to , or to use in functions like Vlookup.

If you select a range of cells and include the heading labels, however if the heading label starts with a number ie: 2017 Budget Excel will add the underscore.

  1. Select the cells – include the heading
  2. Formulas tab, Define Names Group
  3. Select Create from Selection
  4. This will Automatically detect the heading name and use it for its range name. However generally you can not start a range name with a number so Excel will compensate by adding an underscore at the beginning. ie:_2017_Budget.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s