How to Remove Borders from Linked Excel Tables in PowerPoint
Question details
The user wants to insert an Excel table into a PowerPoint slide as a linked object without showing the default visible border around it.

- Product
- PowerPoint, Excel
- Device & OS
- not provided
- Scenario
- Creating a dynamic presentation that requires live data updates from an external Excel workbook without the rigid and unwanted outline borders typical of embedded OLE objects.
- Observed behavior
- When pasting an Excel table as a linked Worksheet Object into PowerPoint, a solid border often appears around the object by default, disrupting the slide's visual design.
Ensure both your source Excel workbook and the target PowerPoint presentation are saved locally on your device in their final folder locations before creating links to prevent broken references.
Remove Borders Using Format Object Settings
This is the standard and most reliable method to link an Excel worksheet object while modifying its properties to hide the outline border.
By using the 'Paste Link' feature, PowerPoint maintains a live connection to the source Excel file. You can then use the native object formatting tools to turn off the line visibility.
Open your source Excel workbook, highlight the cell range or table you want to display, and copy it.
Switch to your PowerPoint presentation, select the desired slide, navigate to the Home tab, click the dropdown arrow under Paste, and select Paste Special.
In the dialog box, select 'Paste Link' and choose 'Microsoft Excel Worksheet Object' from the list. Click OK.
Right-click the newly inserted table on your slide, select 'Format Object', navigate to the 'Colors and Lines' tab (or the Line section in the formatting pane), and set the line color to 'No Line'.
Paste the Excel Range as a Linked Picture
A simpler alternative that maintains the exact visual appearance of your Excel table while allowing automatic updates and easier resizing.
Link Specific Text to Avoid Object Borders Entirely
If you only need the raw data and not the table grid structure, you can link the text directly into an existing PowerPoint text box.
Seamlessly Link Spreadsheets and Presentations in WPS Office
WPS Office offers flawless cross-app integration within a single interface. You can easily link WPS Spreadsheet data to WPS Presentation slides without worrying about clunky formatting or unwanted borders.
- 1. Copy the spreadsheet data: Open your data in WPS Spreadsheet, highlight the desired table range, and copy it.
- 2. Switch to your presentation: Click the tab to switch to WPS Presentation and navigate to the slide where you want the table inserted.
- 3. Use Paste Special: Click the Home tab, click the arrow below Paste, and select 'Paste Special'. Choose 'Paste Link' and select 'WPS Spreadsheet Object'.
- 4. Format to remove borders: Right-click the inserted table, click 'Format Object', navigate to the Line settings in the right pane, and select 'No line'.

Frequently Asked Questions
Why doesn't the linked Excel table update automatically in PowerPoint?
If your linked table isn't updating, your link settings might be set to manual. Go to File > Info > Edit Links to Files, select your Excel file, and verify the update method is set to 'Automatic' rather than 'Manual'.
Can I remove the internal cell borders of the Excel table as well?
Yes. If you paste the table as a linked object or linked picture, any formatting changes made in the source Excel file, including removing or recoloring internal cell borders, will automatically reflect in your PowerPoint slide.
Will the link break if I move the Excel file to another folder?
Yes, moving or renaming the source Excel file will break the link path in PowerPoint. It is best to keep both files in the same relative directory, or you will need to re-establish the link using the 'Edit Links' option.




