Copy Excel Rows into an Email Without Losing Column Formatting
Question details
The user needs to copy rows from a spreadsheet into an email while preserving the original column layout instead of pasting as continuous text.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Sending spreadsheet rows by email while keeping the column structure readable.
- Observed behavior
- Rows pasted into an email appear as continuous text and lose the worksheet column formatting.
Before copying, switch your email message to HTML or rich-text format. In WPS Spreadsheets, make sure the cells or rows you want to send are visible and selected correctly.
Copy and paste rows directly into an HTML or rich-text email
Use this first when you want the fastest way to send spreadsheet rows by email while keeping columns aligned.
Open the workbook in WPS Office Spreadsheets, click the first row number, hold Shift, and click the last row number, or drag across the cells you want to send.
Right-click the selection and choose Copy, or press Ctrl+C on your keyboard.
Open your email client, create a new message, click in the message body, and paste with Ctrl+V or the email editor's Paste command.
Confirm the pasted content appears as a table with separate columns. If it does not, switch the email editor to HTML or rich-text mode and paste again.

Paste the copied range as an image or HTML table when direct paste breaks
Use this fallback if the first paste still shows continuous text or loses column alignment.
Keep Spreadsheet Columns Intact When You Email Rows
WPS Office Spreadsheets lets you copy rows from an Excel-compatible workbook and paste them into an HTML or rich-text email so the column layout is preserved. If the direct paste still fails, use Paste Special to insert the range as a table or image.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office Spreadsheets and open the .xlsx or WPS spreadsheet file containing the rows you want to send.
- 2. Select and copy the rows: Click the row headers or drag across the range, then press Ctrl+C or right-click and choose Copy.
- 3. Paste into a new HTML or rich-text email: Create a new email, click in the body, and press Ctrl+V. Make sure the email editor is set to HTML or rich-text mode.
- 4. Check the pasted columns: Confirm that the rows appear as a table. If not, use Paste Special to insert the copied range as an HTML table or image.

Frequently Asked Questions
Why do Excel rows paste into an email as continuous text?
This usually happens when the email is in plain-text mode. Switch the email editor to HTML or rich-text format, then copy the rows from WPS Spreadsheets and paste them again.
How can I paste spreadsheet rows as a table in Gmail or Outlook?
Copy the range in WPS Spreadsheets, start a new email, and use the editor’s Paste or Paste Special command. In Gmail and Outlook, keep the message in rich-text or HTML mode so columns stay as a table.
What should I do if the pasted columns are still misaligned?
Paste the copied range as an image or HTML table using Paste Special. You can also select the spreadsheet cells, right-click, choose Format Cells, and set them as Text or Number before copying.
Does WPS Office support copying Excel .xlsx rows into an email?
Yes. WPS Office Spreadsheets opens Microsoft Excel .xlsx files and supports copying rows that can be pasted into an HTML or rich-text email while keeping the column layout.




