Excel tips: 25 Name Box techniques

In his latest contribution from across the Atlantic David H Ringstrom explores some of the lesser known capabilities of that little rectangle at the top left of every Excel spreadsheet.

Most Excel users think of the Name Box as the area that displays the address of the currently selected cell. Some people may also use the Name Box as a navigation aid. But don’t be fooled, that unobtrusive little rectangle can lead you towards a dizzying amount of useful techniques within.

Register for free and log into AccountingWEB.co.uk to see all 25 Name Box tips. To explore more ideas, also see Simon Hurst’s popular articles on Excel named ranges.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Name Box Techniques

john.fwtang | | Permalink

Hi David,
Thanks for the article. I cannot use the name box to find the chart and objects and also not able to chart the names of objects. I use Excel 2007. Will appreciate your comment.