Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel powerpoint and

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel / Powerpoint and Formatting

Excel / Powerpoint and Formatting

ResolvedVersion 365

Sarah-jane has attended:
Excel Intermediate course

Excel / Powerpoint and Formatting

I noticed when copying a heat map table of data from Excel to Powerpoint that the formatting i.e. the colours do change. I then find myself having to use the eye dropper to match the colours from the heat map to the table in powerpoint. Is there any way of being able to copy the heat map along with the exact colours? Hope this makes sense.

RE: Excel / Powerpoint and Formatting

Hello Sarah-Jane,

Thank you for your question. When you paste Excel data into PowerPoint, to keep the Excel colours, instead of just pasting, right-click in the slide, then select the second paste option: Keep Source Formatting.

I hope this helps.

Kind regards
Marius Barnard
STL

Mon 12 Dec 2022: Automatically marked as resolved.

Please browse our web site to find out more about
training excel vba and other training courses.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.08 secs.