WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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

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.How_to_link_WPS_Writer_and_Spreadsheet_together_4.gif

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.