Share via

Keep source formatting from Excel to Powerpoint

Anonymous
2015-12-10T10:06:06+00:00

Hi

I have an table in powerpoint, without any cells coloured. Now I updated my excel sheets, colouring certain cells and now I just want to copy this data with the cell colouring into the table in powerpoint, but somehow it only copies the content and not the cell colouring (even when pasting with keep source formatting). Does anyone have a solution for this? It's costing me a lot of time to colour everything in Powerpoint myself. 

Using Office 2013 by the way. Thx in advance,

J

Microsoft 365 and Office | PowerPoint | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-12-10T20:58:06+00:00

    Hi,

    Thank you for posting your query in Microsoft Office Community.

    Let's try following steps and check if it helps.

    1. Copy the content from Excel.
    2. Open PowerPoint, go to Home tab, click on Paste>Paste Special.
    3. Select Paste link>Microsoft Excel Worksheet Objectand press Ok.

    Now whatever update you make in Excel would reflect in Excel as well.

    Hope the above information helps. Try the suggestions and let me know the result at your earliest convenience.

    Thank you.

    30+ people found this answer helpful.
    0 comments
  2. Anonymous
    2015-12-14T10:04:33+00:00

    Hi all,

    Thx for your replies, I guess it's simply not possible what I hoped/wanted. Nevertheless, thx for all the alternative solutions.

    7 people found this answer helpful.
    0 comments
  3. John Korchok 231.6K Reputation points Volunteer Moderator
    2015-12-11T15:19:13+00:00

    If you don't need to maintain a link to the workbook, try some of the Paste Special formats. I just did a quick conditional format on a worksheet copied and in PowerPoint used Home>Paste Special (click on the bottom of the Paste button). Using HTML or Picture (Enhanced Metafile) format retained the cell coloring when I tried it.

    7 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-12-11T09:07:27+00:00

    Hi Vardhaman S,

    Thx for your reply. Though I'm not really looking for a direct link between those programs, As i might need to filter some variables every now and then and don't want that to be reflected in Powerpoint. I just want to copy-paste contents and formatting from a table in excel to an existing table in Powerpoint. Neither is the option to set up teams, since the colouring has a specific meaning.

    To be more clear...

    I copied data from Excel to Powerpoint, then I 'designed' the tables which was fine. After having done multiple tables I realized I had to colour certain cells (f.e. green when score is above 10 and red when below 0), which I applied in Excel since that worked fastest. But than trying to paste the data from excel with the right colouring in the existing tables in powerpoint, I wasn't able to keep formatting. Having to colour every cell myself.

    So is there any way to just copy and paste? (like you can copy and pasta data incl. formatting within excel)

    Thx!

    7 people found this answer helpful.
    0 comments
  5. John Korchok 231.6K Reputation points Volunteer Moderator
    2015-12-11T01:05:59+00:00

    You can preserve this formatting if:

    • You create a Theme file with a set of predefined colors, then apply this to both the Excel and PowerPoint files.
    • You create the cell shading colors out of variants on the theme colors.

    Once both files are using the same theme, colors should transfer without any issues.

    3 people found this answer helpful.
    0 comments