1 / 26

A few tricks to take you beyond the basics of Microsoft Office

A few tricks to take you beyond the basics of Microsoft Office. GCPS Tech Tips. Microsoft Excel: Paste Excel data into other programs. Paste Excel data into other programs.

rachell
Download Presentation

A few tricks to take you beyond the basics of Microsoft Office

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A few tricks to take you beyond the basics of Microsoft Office GCPS Tech Tips Microsoft Excel: Paste Excel data into other programs.

  2. Paste Excel data into other programs. If you have a section of an Excel worksheet that you would like to add to a Word document, to an email, or even to a PowerPoint presentation, there are a couple of ways to do it.

  3. Paste Excel data into other programs. The simple and quick way... is to select the cells you want to copy by holding down the left mouse button until you have dragged your cursor from the upper left to the lower right of the block of cells you want to copy.

  4. Paste Excel data into other programs. Then hold down the “Control” key...

  5. Paste Excel data into other programs. and press the “C” key to copy the group of cells you had selected.

  6. Paste Excel data into other programs. Go to the place where you want to paste the cells... put your cursor where you want the cells inserted... hold down the “Control” key again...

  7. Paste Excel data into other programs. and press the “V” key to paste the cells.

  8. Paste Excel data into other programs. The only drawback with this “quick copy” method is that you get exactly what you copied and you can’t change the look of the cells as much as you could if they were copied as a picture.

  9. Paste Excel data into other programs. To do that... you start by selecting the cells you want to turn into a picture.

  10. Paste Excel data into other programs. Then, hold down the “Shift” key...

  11. Paste Excel data into other programs. as you click “Edit” at the top of your screen.

  12. Paste Excel data into other programs. Holding down the “Shift” key puts a “Copy Picture” choice on the drop-down menu that wouldn’t be there otherwise. So click “Copy Picture”.

  13. Paste Excel data into other programs. That opens the “Copy Picture” dialog box. On it, you click the “As shown on screen” option.

  14. Paste Excel data into other programs. Then click of the “Picture” option...

  15. Paste Excel data into other programs. and click “OK”.

  16. Paste Excel data into other programs. Now, open the program where you want to paste the Excel picture.

  17. Paste Excel data into other programs. Hold down the “Control” key...

  18. Paste Excel data into other programs. and press the “V” key to paste the picture.

  19. Paste Excel data into other programs. The Excel picture appears in the document.

  20. Paste Excel data into other programs. If you click on the picture once, you can move it around or resize it by dragging it by its little black “handles.”

  21. Paste Excel data into other programs. Or double-click on it to open the “Format Picture” dialog box... which will let you change its size, layout, fill color, line color, and so on.

  22. Paste Excel data into other programs. If you want the cells without gridlines, you have to turn off the gridlines before you copy the cells. You do that by clicking on “Tools” at the top of your worksheet screen...

  23. Paste Excel data into other programs. then click on “Options” in the drop-down menu...

  24. Paste Excel data into other programs. and in the “Options” dialog box, remove the checkmark next to “Gridlines”...

  25. Paste Excel data into other programs. and click “OK”.

  26. Paste Excel data into other programs. That’s all there is to it. Now, if you would like a copy of the step-by-step directions for pasting Excel data into Word, just print this last page. Have fun pasting!

More Related