'%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 Keep Excel Borders When Pasting into Word
Question details
The user needs to maintain original Excel formatting, specifically cell borders, shading, and alignment, when copying tabular data into a Word document.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Copying timesheets or tables from an Excel spreadsheet and pasting them into Microsoft Word.
- Observed behavior
- Cell borders, shading, and text alignment are frequently lost or altered after pasting the Excel data into Word due to default paste settings.
Ensure both your Excel spreadsheet and Word document are open, and carefully select the exact range of cells you wish to copy before attempting to paste.
Use 'Keep Source Formatting' in Paste Options
This is the most reliable way to retain editable Excel borders and cell shading within your Word document.
Microsoft Word often defaults to matching the destination formatting, which strips away the custom borders and shading you applied in Excel. Adjusting the Paste Options immediately after pasting ensures the original design is imported accurately.
Highlight the desired cell range in your Excel spreadsheet and press Ctrl+C to copy.
Navigate to your Word document, click where you want the table to appear, and press Ctrl+V.
Click the small 'Paste Options' clipboard icon that appears at the bottom right of the pasted table.
Choose the 'Keep Source Formatting' option (the icon featuring a paintbrush and original layout) to instantly restore your Excel borders and alignments.
Paste Special as a Picture
Best for situations where visual fidelity is paramount and you do not need to edit the data inside Word.
Manually Reapply Table Borders in Word
Use this fallback method if formatting is lost due to overriding document themes and cannot be restored via Paste Options.
Easily Keep Excel Borders Intact Using WPS Office
WPS Office offers native and seamless integration between its Spreadsheet and Writer applications, allowing you to copy tables with all borders, shading, and alignments perfectly preserved without complex formatting adjustments.
- 1. Copy Data from WPS Spreadsheet: Open your workbook in WPS Spreadsheet, select the cells you want to migrate, and press Ctrl+C.
- 2. Switch to WPS Writer: Open your destination document in WPS Writer and place your text cursor at the desired insertion point.
- 3. Paste with Source Formatting: Right-click the mouse and select 'Keep Source Formatting' from the context menu to perfectly retain your table's design.
Frequently Asked Questions
Why does Word automatically remove my Excel table borders?
By default, Microsoft Word may be set to 'Use Destination Styles' when pasting. This automatically applies the default Word document theme to incoming data, which often strips custom Excel formatting like borders and shading.
How can I link an Excel table so that data updates automatically in Word?
After copying your table, go to Word and click the Paste Options icon. Choose the 'Link & Keep Source Formatting' option. This preserves your Excel borders while keeping the table linked, meaning any data updates in Excel will automatically reflect in the Word document.
Can I edit the text if I use Paste Special to paste the table as a picture?
No, pasting the table as a Picture or Bitmap rasterizes the content into an image file. While this guarantees 100% visual accuracy for borders and shading, you will not be able to edit the text or numbers inside Word.
