Paste As Link

Posted: May 27, 2013 by Theodoulus in Excel
Tags: , , ,

Situation:
You have created a dashboard in which you have applied all the required formatting like border, color, cell merge, background, font- style, margins, row-column height or width etc. You have data in the dashboard and you have spent many hours in this whole creation.
What if you want to show the same dashboard in a different sheet too (means all the efforts you did in the previous sheet while creating that dashboard).
Solution: In this situation, Excel provides us “Paste Picture link” by which we can get all the desired output. You just need to copy the range of the dashboard that you created and paste it anywhere you want as “Paste Picture Link”. Now you are the GOD for the dashboard means if you are extending the row height, unmerge the merged cell, giving different background image and even your data is dynamic (getting changed automatically) or anything else you want in your Parent dashboard.
“THE ALL CHANGES WILL GET REFLECTED IN THAT PICTURE LINK WHERE YOU PASTED IT”.

Isn’t this a smart way of doing things!
So how to accomplish the task, let’s see:

First Create you Dashboard………………………..
a1
Now Select the range or the whole area of the dashboard and copy it.
Go to that place where you want this to be pasted and find the paste option on the HOME tab and Paste Picture Link

a2

Now whatever change would come in the original Dashboard will be reflected in the Picture Link which you have pasted.

See You Soon…………

Advertisements

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s