Everything you need to know about Excel range names

istock_RapidEye_excel
istock_RapidEye_excel
3

Almost since the beginning of time, as measured by AccountingWEB, Excel tips have been popular on both the U.S. and the UK AccountingWEB sites. And of all the myriad Excel tips that have been published on both sides of the Atlantic, none have been more well-read and virtually dog-eared than those about range names. Here is the latest Excel range name Q&A coming out of our UK site, with links to more of our outstanding Excel range name tips at the bottom.

Introduction
It is possible to allocate a name to an Excel cell or a block of cells and even directly to an Excel formula. Names can be used to make navigation and selection easier and can be used in place of cell references to make formulae easier to understand. Until the 2007 version, Excel’s own tools for managing names were fairly minimal, although third-party add-ins are available. Excel 2007 introduced the new Name manager feature which provided a set of basic tools for managing names.

What’s the quickest way of allocating a range name to a cell or block of cells?
Names can be created by using the Formulas, Defined Names, Define Name option (Excel 2003 menu: Insert,-Name- Define). However, a quicker

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

admin
Blogger
Share this content

Replies

Please login or register to join the discussion.

avatar
By M L S
Jun 26th 2015 01:11

why can't we use spaces to named ranges???

Thanks (0)
avatar
By Jerry
William
Jun 26th 2015 01:11

Because the space sign is a operator in excel (like +, -, *).

Thanks (0)
avatar
By Bharath S
Jun 26th 2015 01:12

Can we use the same range name in different workbooks?? Is it possible?

Thanks (0)