How to Paste PowerPoint Table Text Without Changing Destination Formatting
Question details
Users need a way to copy and paste multiple rows or cells into a PowerPoint table while preserving the destination table's existing text formatting.

- Product
- PowerPoint
- Device & OS
- not provided
- Scenario
- Copying multiple cells or rows from one table and pasting them into another existing table within a presentation.
- Observed behavior
- The destination table's formatting changes to match the source. The 'Keep Text Only' option disappears when multiple cells are selected, making it difficult to maintain destination formatting.
Ensure you have your destination table pre-formatted the way you want it before pasting new data. If copying from an external source, you may want to paste the data into a plain text editor first.
Use Paste Options and Format Painter
Since preserving destination text formatting for multiple copied cells is a known limitation in PowerPoint, the best approach is to paste the data and quickly restore the formatting using the Format Painter tool.
When copying multiple cells, PowerPoint often hides the 'Keep Text Only' option. This means the copied text will overwrite your destination table's design. Using the Format Painter allows you to copy the correct style from an unaffected cell and apply it instantly to the newly pasted data.
Select the target area in your destination PowerPoint table and press Ctrl+V (or Cmd+V on Mac) to paste the copied rows or cells.
Click the Paste Options button that appears at the lower-right corner of the pasted table and select 'Use Destination Style' to apply the closest layout match.
Click inside a cell in your destination table that still has the correct text formatting.
Go to the 'Home' tab on the ribbon and click the 'Format Painter' icon. To apply the format to multiple cells, double-click the icon.
Click and drag your cursor over the newly pasted cells to apply the original destination text formatting to them.

Paste Content Cell by Cell
If you are only transferring a small amount of data, pasting cell by cell bypasses the multi-cell limitation and restores the 'Keep Text Only' option.
Try WPS Presentation for Seamless Table Editing
Struggling with PowerPoint's table formatting bugs and limitations? WPS Office offers a highly compatible, free alternative with intuitive table management and seamless formatting controls, making presentation design significantly easier.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Presentation: Launch WPS Presentation and open your existing PPT or PPTX file.
- 3. Edit Your Tables: Copy and paste your table data effortlessly with full control over source and destination formatting.

Frequently Asked Questions
Why does the 'Keep Text Only' option disappear when pasting in PowerPoint?
PowerPoint has a known product limitation where the 'Keep Text Only' paste option becomes unavailable when you select and copy multiple table cells or rows at once, particularly on Mac. It usually only appears when copying text from a single cell.
How can I paste a table from Excel to PowerPoint without bringing over the formatting?
To strip away Excel formatting before pasting into PowerPoint, copy your Excel table and paste it into a plain text editor like Notepad or TextEdit first. Then, copy that plain text and paste it directly into your PowerPoint table.
Does 'Use Destination Theme' keep my exact destination font size?
Not always. While 'Use Destination Theme' applies your presentation's overall theme colors and default fonts, it may overwrite specific, customized cell-level formatting like unique font sizes or text weights that were present in the destination table.




