+ Reply to Thread
Results 1 to 2 of 2

Copy and Paste Excel Table as a Picture

  1. #1
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    Copy and Paste Excel Table as a Picture

    hi,

    I am trying to create an automated report for calculating and presenting various data.

    In different stages of processing the report I want to capture data from tables with conditional formatting and different colors.

    Everything works great at the beginning of the report when there are 20-30 rows in the table.

    When the table reaches 100 rows some of the conditional formatting and colors pass to the image I captured and some do not pass.

    Is there any Limitations on copying an image from cells
    Is there an easy way to do this in large tables?

    Thanks in advance

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,877

    Re: Copy and Paste Excel Table as a Picture

    With your file open, click on File-->Options-->Customize Ribbon

    In the Option box at the top select "Commands Not in the Ribbon"

    Scroll down to Picture (Paste as Picture) and insert it onto the Ribbon where you believe it will best serve you.

    This is an old function in Excel that has been removed from the most popular Ribbon functions.

    Then it is just a case of copy and paste using this function as the paste feature.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy cells from Excel and paste as a picture in an email.
    By oneyejack77 in forum Excel General
    Replies: 4
    Last Post: 04-09-2018, 12:22 PM
  2. Macro to copy/paste picture of table in Excel worksheet into a Word document
    By grbears in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-25-2017, 11:25 AM
  3. Copy and paste Excel range as picture into Outlook email body using excel vba
    By ExcelDoc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2016, 09:29 PM
  4. excel 2010 VBA. Copy range as picture > paste > resize ?
    By bluphoto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2014, 12:47 PM
  5. Run time error 1004 on picture copy and paste - excel 2010
    By talon10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2014, 08:14 PM
  6. Copy table as picture, paste into another tab and align
    By excelsias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2014, 02:14 PM
  7. Replies: 1
    Last Post: 10-01-2012, 11:11 PM

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