How to Send Individual Excel Columns to Different People in WPS Office
Question details
The user needs to send each column of an Excel schedule to the corresponding recipient as a separate email attachment or email content, without exposing other people's schedules.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has an Excel schedule where one person's schedule is stored per column, and each column needs to be sent separately to that person.
- Observed behavior
- The schedule currently lives in one workbook with one person per column, and the user needs a way to deliver each column only to the intended recipient.
Open the schedule in WPS Spreadsheets and confirm that each column header clearly identifies the recipient or email address. Also make sure your email application is installed and configured if you plan to attach files.
Send Each Column as a Separate WPS Spreadsheets Attachment
Use this manual method when you have a small number of recipients or send the schedule occasionally.
This method keeps your master schedule intact. You copy only one column into a new WPS Spreadsheets workbook, save it, and attach that file to an email. No VBA or external automation is required.
Launch WPS Office, click Spreadsheets, and open the Excel schedule file that contains one person's schedule per column.
Click the column letter at the top of the schedule column you want to send, so the entire column is highlighted.
Press Ctrl+C, click the Menu button in the top-left corner, choose New > Blank workbook, and press Ctrl+V to paste.
If more than one column was pasted, right-click the unwanted column letters and choose Delete so only the intended recipient's schedule remains.
Click the Menu button > Save As, choose Excel Workbook or PDF, name the file for the recipient, then attach it in your email app. In versions with a share option, use Menu > Share > Send as Attachment instead.
Automate Recurring Delivery with Power Automate or VBA
Use this optional method when you need to send schedule columns repeatedly to many people and you have access to Microsoft Power Automate or Outlook.
Send Individual WPS Spreadsheets Columns to Each Recipient
Open the schedule in WPS Spreadsheets, copy each person's column into a separate workbook or PDF, and send it as an email attachment. Because WPS Office is compatible with Excel .xlsx files, your original schedule opens directly without conversion.
- 1. Open the Excel schedule in WPS Spreadsheets: Launch WPS Office, click Spreadsheets, and open the .xlsx file containing the schedule.
- 2. Select and copy only the recipient's column: Click the column letter to highlight it, press Ctrl+C, open a blank workbook, and press Ctrl+V to paste.
- 3. Save the column as a separate file: Click the Menu button > Save As, choose Excel Workbook or PDF, and name the file with the recipient's name.
- 4. Attach and send it to the matching recipient: Open your email app, attach the saved file, enter the recipient's address, and send. Repeat for each person until all columns are delivered.
Frequently Asked Questions
Can WPS Spreadsheets automatically split and email each column by itself?
WPS Spreadsheets does not have a built-in send-one-column-per-recipient button. The reliable manual method is to copy the selected column into a new blank workbook, save it as .xlsx or PDF, and attach that file to the recipient's email.
How do I make sure recipients cannot see other people's columns?
Open a new blank workbook and paste only the intended column there, or delete all unrelated columns before saving. Do not email the master workbook.
Can I send the column as a PDF instead of an Excel file?
Yes. In WPS Spreadsheets, select the column or set the print area, then click the Menu button > Save As > PDF. Each PDF will show only the selected schedule.
Does the VBA method work in WPS Office?
VBA support in WPS Spreadsheets can vary by version and platform. For automated recurring email, Microsoft Power Automate with Excel Online and Outlook is often more predictable; for occasional sends, the manual WPS method is simplest.
