Linking to a Data Range in a Spreadsheet

LO5 :: To be able to select and present information in the development of the solution to meet an identified need
Dividing Line


If you need to print this page out, type your name in the box below.

Your Name : 



Information

If you need to show some specific data in a spreadsheet it might be better to to link to the cells that contain the data rather than the whole spreadsheet.

Open the document and the spreadsheet file together.  You might want to have both windows open side by side you your screen.

Word Processinfg


In the spreadsheet file select the area to be linked and right-click and choose Copy.

Word Processing


Now go to the document and select where you would like the data inserted.  Right-click then choose either of the Paste Link Word Processingoptions from the pop-up menu.

Word Processing


When you change some of the data in the spreadsheet file, it will be automatically updated in the document at the same time.  You can also press F9 Word Processingto refresh your data at any time.


DoIT

Now have a go at completing this practical activity.


Practice IT Linking and Embedding

PrintIT  Print out this Page

Next Adding a Presentation Slide to a Document


Last modified: Sunday, 26 July 2020, 11:38 AM