Formatting Issues

How to Paste PowerPoint Table Text Without Changing Destination Formatting

Steve KSteve K Nov 3, 2026 870 views

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.

How to Paste PowerPoint Table Text Without Changing Destination 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.
Before you start

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.

Solution 1Recommended

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.

1
Paste the copied cells

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.

2
Apply destination theme

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.

3
Select a correctly formatted cell

Click inside a cell in your destination table that still has the correct text formatting.

4
Activate Format Painter

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.

5
Restore text formatting

Click and drag your cursor over the newly pasted cells to apply the original destination text formatting to them.

Use Paste Options and Format Painter
Submit Feedback: Because the lack of a multi-cell 'Text Only' option is a product limitation, Microsoft recommends submitting a feature request through the PowerPoint feedback channel.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open Your Presentation: Launch WPS Presentation and open your existing PPT or PPTX file.
  3. 3. Edit Your Tables: Copy and paste your table data effortlessly with full control over source and destination formatting.
Completely free to download and use for all basic office needsFully compatible with Microsoft PowerPoint (.pptx) file formatsAdvanced and intuitive table formatting controls to streamline workflowLightweight application with a familiar, easy-to-navigate user interface
microsoft office alternative - wps office

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.