Tuesday 18 July 2017

Microsoft PowerPoint - Insert Excel data

You can insert an Excel  table by choosing from a selection of preformatted tables or by selecting the number of rows and columns that you want.

Copy and paste (unlinked) Excel data into PowerPoint:
1. In Excel, open the workbook with the data you want to copy.

2. Drag over the area of data you want to copy, and on the Home tab, click or tap Copy.

3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

4. On the Home tab, in the Clipboard group, click the arrow below Paste.

5. Under Paste Options, pick one of the following:
  • Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation.
  • Keep Source Formatting to copy the Excel data as a PowerPoint table, using the format of the spreadsheet.
  • Embed to copy the data as information that can be edited in Excel later.
  • Picture to copy the data as a picture that can't be edited in Excel.
  •  Keep Text Only to copy all the data as a single text box.


No comments:

Post a Comment