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 thencopy and paste the data table into Word.

Sup data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/dbbe6ab906580b0071f02900d2a3daf8_0.46_6574.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

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

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 cop data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/ad1cbaa5b018c0e688328bab1e6b5759_0.46_3791.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

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  data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/fa437967e432940030a294f5063d0fa9_0.46_1489.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

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 underthe Paste link and click OK.

By doing so, when the data in Wp data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/203d6969a5d0d89303fad120272947f8_0.46_5138.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

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.