Formerly Best Training
© 2024 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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel / Powerpoint and Formatting
Resolved · Low Priority · Version 365
Sarah-jane has attended:
Excel Intermediate course
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.
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.
|
Excel tip:Turn Function tooltips on and offExcel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are! |
We'll call during UK business hours
Server loaded in 0.49 secs.