Excel tips: 25 Name Box techniques

Columnist
Share this content
1

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.

Please Login or Register to read the full article

Replies

Please login or register to join the discussion.

Name Box Techniques
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.

Thanks (0)