When working with Range Names in Excel, to save you trying to remember the names you use, or making them too short and unfriendly to make them rememberable, this week`s tip should be one of your best friends.
To display a list of range names within a workbook, just press the F3 key. You can then select the range you require for use in formulas, pivot tables or anywhere else you choose.
Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.