How to link quickly any cell reference in Excel sheets.
Here are the steps:
1) Copy the range you want to link to the other sheet.
2) Copy
3) Go to the destination sheet or cell/range where you want to create the link. Right Click and select Paste Special and then click on "Paste Link" option given below the popup window. ( or use ALT+ E + L)
Blog Archive
Labels
- Best Excel Books (1)
- Best Excel Website (1)
- Dynamic Chart in Excel (1)
- Excel (1)
- Excel Books (1)
- Excel Shortcuts (1)
- Excel Tips (1)
- ISERROR Macro (1)
- Selection of only visible cells in Excel (1)
- VBA (2)
- VBA Books (1)
Disclaimer
Please note this blog is only to share information and knowledge and all my own views. I will publish the source of the original authors wherever applicable. Compliments are graciously accepted and appreciated. Criticisms and reproaches are fine if you have a problem with something, but my decision prevails over what I want to say and write on my blog. 'Comments' on this blog are NOT moderated. I am not responsible for any comments posted on any entry.
Posted by
Dibyendu.Sharma
Monday 15 June 2009
Labels:
Excel Tips
Subscribe to:
Post Comments (Atom)