Search Not Just Numbers

Tuesday, 22 July 2014

Excel Tip: Quickly name and access ranges

A quick reminder before we start, that the 20% off deal on Mynda Treacy's Excel Dashboards course expires on Thursday. So, if you want to take advantage, hop on over there now while you've still got the chance.

This week, I've got a simple tip to quickly name and access ranges in Excel.

You can use the Name Manager on the Formulas ribbon to define range names, however I will show you a much quicker way to name fixed ranges, as well as go to them and highlight them once they exist.

This tip uses the Name Box at the top left of your screen, just below the ribbon to the left of the formula bar.

This box normally shows the cell reference of the active cell (the cell that is currently selected). If you click in cell B6, for example, you will see the name box shows "B6".

While you are in cell B6, click in the Name Box and type the name "Fred". Click in another cell and the name box will change to the cell reference of the cell you have clicked in. Now click back on cell B6 and notice what happens. The Name Box says "Fred"! You have successfully renamed B6, Fred!

You can do the same thing with a range of cells. If you highlight the range C5:E10, for example, and type "Bill" in the Name Box, click in another cell and then re-highlight the range C5:E10, the Name Box will show "Bill" again.

Note that these names follow the same rules for named ranges named in any other way - most notably, they should not include any spaces.

What's more, if you click the dropdown arrow next to the Name Box, you will see Bill and Fred are both listed there. If you select one of them from the list, you will go to that range and highlight it. This works from any of the other worksheets in the workbook too.

You might not find too many reasons to name cells Bill or Fred, but if B6 was renamed TaxRate, then that might be useful. You could use the name TaxRate in any formula (instead of B6) and if you need to check what the TaxRate is, or change it, you can go to that cell by selecting it from the dropdown in the Name Box.

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".


  1. Having replica watches uk, to receive imitation shoes and boots is an effective investment decision considering that the importance will increase after some time. Hermes duplication stands out as the smart choice for just a extravagance model devoid of forking over a superior selling price. It's really a top notch alternative to popular an original type, giving identical fake prada bag, hint in addition to stench on the authentic. This can be the similar consequence for getting imitation shoes and boots to include in ones clothing collection. There is absolutely no superior technique to manufacture a vibrant replica tag heuer in relation to currently being vogue cognizant in comparison with by means of using just one with this household connected with vogue. Most of these vogue replica watches uk usually are popular with regard to excellent in addition to generating a record. The favourite currently being trousers. They've been categorised during men's outfits intended for many a long time. Even so, in this era. Vogue movements include modified and maybe they are at this point utilized by means of both ladies and men based on the glimpse that you wishes to accomplish. They might be for cosmetic or maybe to be a electric piece based on the man or women using the item. fake louis vuitton bags were being typically affiliated because of the armed forces in addition to were being utilized seeing that designs. Nowadays, they've already received the latest set up the fashion marketplace and have absolutely also been enhanced into a place of prominence.

  2. All of these recovery start from leisurewear and additionally your own gear to make sure you supplements manufactured to increase the gratification about travelling and additionally buying a high class used car right from contributing car and motorbike develop. replica dior bags Quite often prominent just by most of the superior type and additionally determination superior quality all of these gear really are a manifestation about private trend focused at working with a meaning about your own well-being. dior replica Each, all of these existence gear create a selective directory of the extremely fabulous presents to select from right from contributing car and motorbike develop. replica louis vuitton That you can buy are often the antique recovery composed about beautiful product for your needs additionally your place; burberry replica recreation recovery by means of tastes from country about motorsport in addition to a fabulous miniatures arranged. replica gucci handbags Wonderful trend is normally recognisable directly, particularly when it’s designed from the prime degree art.