'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Paste Excel Cells into PowerPoint Without Shading
Question details
The user wants to copy Excel values and text into PowerPoint without transferring the source cell shading or formatting.
- Product
- Excel, PowerPoint
- Device & OS
- not provided
- Scenario
- Pasting data from an Excel spreadsheet into a PowerPoint slide.
- Observed behavior
- When pasting Excel cells into PowerPoint, unwanted cell shading or background colors appear, even when trying to paste as plain text or without source formatting.
Make sure you have copied the correct cells from your Excel spreadsheet before attempting to paste them into your PowerPoint presentation.
Use PowerPoint's Paste Options
Use the built-in paste options to strip the original Excel formatting and keep only the text or use the destination slide's styles.
Select the desired cells in your Excel spreadsheet and press Ctrl+C to copy them.
In PowerPoint, right-click on the specific area of the slide where you want to paste the data.
From the Paste Options menu, choose 'Keep Text Only' (the icon with an 'A') to paste the data without any shading or formatting.
Alternatively, select 'Use Destination Styles' to match the pasted data to your presentation's current theme while dropping the Excel-specific background colors.
Report Temporary Office Version Bug
If unwanted shading persists despite using the correct paste options, it may be a known issue in specific Office versions (e.g., version 2405).
Try WPS Office for Seamless Copy-Pasting
If you're frustrated by formatting bugs and glitches in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative where transferring data between spreadsheets and presentations works flawlessly.
Frequently Asked Questions
Why does my Excel data have a colored background when pasted into PowerPoint?
By default, PowerPoint may try to retain the source formatting of the Excel cells. To prevent this, you should use the 'Keep Text Only' paste option instead of standard pasting.
Can I remove the shading after I have already pasted the cells?
Yes. Select the pasted text box or table in PowerPoint, go to the 'Shape Format' or 'Table Design' tab on the ribbon, and set the 'Shape Fill' or 'Shading' to 'No Fill'.
What is the keyboard shortcut to paste as plain text in PowerPoint?
You can press Ctrl + Alt + V to open the Paste Special dialog, then select 'Unformatted Text' to paste your Excel data without any cell shading or styling.
