How to link WPS Writer and Spreadsheet together

Uploaded time: March 11, 2022 Difficulty: Beginner

How to link WPS Writer and Spreadsheet together

How to link WPS Writer and Spreadsheet together

How to link WPS Writer and Spreadsheet together

In today's lesson, we will learn how to use the Paste link function in reality.

In the workplace, we need to use Word to regularly report our work to the leader.

Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. 

Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?How_to_link_WPS_Writer_and_Spreadsheet_together.gif

The correct operation should be: Select the table, press CTRL+C to copy, then switch to the page in Word.How_to_link_WPS_Writer_and_Spreadsheet_together_1.gif

Under the Home tab, click the Paste drop-down button, click the Paste Special button to pop up the dialog box, where you can select WPS Spreadsheets Object under Paste link, click OK, and then you can copy the table into Word.How_to_link_WPS_Writer_and_Spreadsheet_together_2.gif

There are two advantages. First, when the data changes in WPS Spreadsheet, the data in Word changes accordingly.

For example, I need to update the headline of the monthly Human Resource Management report from February to March. Meanwhile, we may modify the table's background color, which will affect the datasheet transferred to Word.How_to_link_WPS_Writer_and_Spreadsheet_together_3.gif

That is to say, when we make monthly reports in the future, we only need to update the data directly in WPS Spreadsheet.

Second, the copy-pasted table is in the form of an image, which can be easily moved. When we double-click the image of the linked table, the Excel Spreadsheet will be opened directly.

When reporting, monthly data are often summarized in the text. You can use this function to paste statistical data in text form.

For example, we need to report the total number of existing employees in March. Go back to WPS Spreadsheet and copy the statistical data in cell G6. Put the mouse cursor at the horizontal line. In the Paste Special dialog box, select Keep Text Only under the Paste link and click OK.How_to_link_WPS_Writer_and_Spreadsheet_together_4.gif

By doing so, when the data in WPS Spreadsheet changes, the text in WPS Writer will also change.How_to_link_WPS_Writer_and_Spreadsheet_together_5.gif

In this way, you can greatly improve efficiency when making working reports. Did you get it?

WPS Office is a free office software that is capable of creating and editing different file formats, including texts in Writer, Presentation, Spreadsheet, and PDF. No matter if you are a student or a business runner, WPS Office is a top choice. WPS Academy, along with WPS Office, offers free and useful tips to beginners who don't know where to start. In addition to the basic functions, WPS Academy can also take you to the more advanced world of office software.