Excel / Powerpoint and Formatting

Resolved · Low Priority · Version 365

Mon 5 Dec 2022, 11:39 Delegate Sarah-jane said...

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.

Mon 5 Dec 2022, 13:15 Trainer Marius said...

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.

Excel tip:

Turn Function tooltips on and off

Excel 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!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Excel / Powerpoint and Formatting

Excel / Powerpoint and Formatting

RE: Excel / Powerpoint and Formatting

Excel articles

Excel tip:

Turn Function tooltips on and off