anything in Excel...

It's Excel-o-lozy...

Tip - Paste Reference of copied range

Easy Excel tip, but hardly known or used:

Sometimes we need to enter reference through a formula to a range in Excel, contiguous cells or joint.
A quick method is using "Paste Special"...

Copy the range, go to cells where you want to put reference and goto "Paste Special" and click "Paste Link", a button at bottm left corner and see the magic...

Now don't ask me how to do a "Paste Special"...

0 comments: