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"...
Sometimes we need to enter reference through a formula to a range in Excel
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:
Post a Comment