Attachment Issues

Copy Excel Rows into an Email Without Losing Column Formatting

John WilsonJohn Wilson Nov 13, 2026 870 views

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.

Copy Excel Rows into an Email Without Losing Column Formatting
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 you start

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.

Solution 1Recommended

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.

1
Select the rows in WPS Spreadsheets

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.

2
Copy the selected rows

Right-click the selection and choose Copy, or press Ctrl+C on your keyboard.

3
Start a new email and paste

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.

4
Check the column layout

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.

Copy and paste rows directly into an HTML or rich-text email
Expected result: With HTML or rich-text email format, the pasted range normally keeps its column formatting.
WPS Spreadsheets

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. 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. 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. 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. 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.
Preserves spreadsheet column layout when pasting into emailOpens and saves Microsoft Excel .xlsx files without conversion issuesFamiliar spreadsheet tools for selecting, copying, and pasting rowsFree, lightweight office suite with no subscription
microsoft office alternative - wps office

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.