When creating formulas, one of the most common mistakes is to use an absolute reference when it should be relative or vice versa.
This week`s tip doesn`t deal with how to avoid errors in this situation, but it does provide a method of switching cell references between absolute and relative very easily.
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.