Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)

As mentioned in my previous post, I am going to talk about another built-in function that is not commonly used (in my limited community)… 😛

COPY, PASTE linked picture (aka “Camera”, which is actually available in Excel 2003; not sure if even earlier)

I think the term “Linked Picture” is more descriptive.  Excel 2010 tries to make it more visible by putting it under Paste Special options but I doubt how many users have noticed that…

In short, that is a picture linked with cell reference.  E.g. if you link the picture to B1:E4, whatever fall onto the range B1:E4 will appear on the picture.  See example below:


You may see the linked range in the formula bar.

So what does it do to me?

To me, it’s a handy tool if I want to put  tables of different sizes on the same page.  Actually, it’s quite common in preparing dashboard.

Think about this:

You have create a chart-like table below:


And on Sheet 2, you have a summary table.


What you want is to put them together.  If you simply copy the summary table on Sheet 2 and paste it on top of the table on Sheet 1, you will get this ugly result:


Given the differences in the column width, it could be timing consuming in merging cells in order to display the summary table correctly.

With linked picture, it can be done easily with no hassle in merging cells.  At a glance, you might think that there is a table overlaid on another table.  🙂


To achieve this, just a few simple steps would do:

1) Select the range you want to copy, in this case A1:E5 on sheet 2.  Then CTRL C (copy)


2) Right Click the cell where you want to Paste.  In this case, A3 on Sheet 1.


3) Under Paste Special, Select the lower right icon for “Linked Picture”

4) Pls note that when you select the picture, you may see the “Linked Range” in the formula bar.


5) You may now resize/move the “Linked Picture” as if a normal picture in Excel


  • Whatever you change on the linked range, it will show up on the linked picture immediately
  • If you are using Excel 2003 or before, you won’t see “Linked Picture” under Paste Special.  What you can do is to first insert a regular picture.  Then you select the picture and type the range (e.g. “A1:E5”) directly in the formula bar.


  1. the printing quality of a linked picture is not as good as a normal range / table.
  2. Text may be distorted if the size of the linked picture deviated largely from the original cell reference/range


Watch it in my YouTube Channel:




About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , , . Bookmark the permalink.

6 Responses to Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)

  1. atefeh says:

    how can I center text bottoms in slicer?


  2. says:

    I use this all the time, but it seems to be broken in the latest (insider slow) version of Excel 2016. If you copy a range, and then paste it as a linked picture it looses some of the content and there is no way to get it to display it all. Have you seen this?

    Liked by 1 person

    • MF says:

      Thanks for sharing this finding.
      I rarely use Excel 2016… I have no clues.
      Let’s me test it if I have a chance later. Any other users experience the same?


    • MF says:

      I just tried in a 365 version and it works.
      Maybe you should feedback to Microsoft esp. you are using an “insider” version.


  3. vishwas1980 says:

    Hi , Could you kindly share the example workbook shown .It will be very helpful.thank you


    • MF says:

      Hi vishwas,
      Thanks for your suggestion.
      The truth is I don’t know how to put the file here… 🙂
      To cover up this, I would suggest you follow the steps and create the content from scratch. You will experience and learn more in this way. 🙂


Comments, suggestions, corrections are welcome.

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.