If you`ve created a range name in Excel (probably by selecting the cells in question an typing the required Range Name in the Name Box) but want to modify it, it cn be a real pain sometimes to remember where you find the relevant menu entry.
Once you`ve remembered, selecting Insert, Name and Define is still a bit of a long winded way to do something which should be pretty simple.
Hold down Ctrl and press the F3 key.
That`s all - the define name dialog box appears as if by magic.
Have a good week.
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.
|Sheri Ann Richerson|