+ Reply to Thread
Results 1 to 3 of 3

How to paste an image into the cell/comment

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    RU
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to paste an image into the cell/comment

    When you simply paste an image into Excel, it will be placed on the drawing layer "above" the cell grid, and this means that the image will always float.

    Option 1. To embed your picture into a spreadsheet, you can paste it into the comment box:
    • Add a comment to the cell.
    • Right click the cell and select Show/Hide Comments. Right click the border of the comment and select Format comment.
    • Open the Colors and Lines tab and select Fill effects from the Color drop down box.
    • Select the picture tab and browse for the picture you want to insert.
    • To keep the picture default aspect ratio, add a check mark to Lock Picture Aspect Ratio.
    • Selected picture will be inserted as a background for the comment.

    \1

    You can also type text in the comment box as usual and it will be shown on top of the picture.

    Option 2. Using add-ins. Since pasting pictures in comments has several shortcomings, another option is an add-in that allows to create comments as ordinary Word documents. In this case you need to add a note with a Word document and just paste your image there. (this add-in is XLnotes for those who are interested Disclosure: I'm related to the development of this add-in).

    \1

    Option 3. Just pasting the image on the worksheet and aligning it (this feature is available in Excel 2007 and higher).
    To align multiple pictures do the following:
    • Select the pictures that you want to align.
    • Under Picture Tools, click the Format tab.
    • In the Arrange group, click Align, and chosse one of the alignment options.

    \1
    Last edited by excev; 07-26-2012 at 06:36 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How to paste an image into the cell/comment

    Wild guess - you work for, or are, the creator of XLnotes?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    RU
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to paste an image into the cell/comment

    Yes, in my greetings post I said that i'm a developer of XLnotes and I hope it's relevant for the topic I've opened. (well, actually XLnotes was made to address the issue with pasting images in Excel) Should have stated it clearer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1