About Qweas     RSS Feeds     BBS Forum Make Qweas.com My Home Page     Bookmark this page Register     Login     Help     Send Feedback  
Windows Mac Linux
Mobile Games Screensavers
Audio/Video Business Communication Desktop Develop Education Games Graphic Home Network Security Servers System Web
Software Guides
Audio MP3 Software Guides
Video DVD Software Guides
Graphics Software Guides
Antivirus Software Guides
Internet Software Guides
Pocket PC Software Guides
Ripper & Converter Guides
Makers and Designers Guides
Business Software Guides
Education Software Guides
Web Development Guides
Game Guides | System Guides
Hot Software Guides Recommend:
How to convert Napster protected music to MP3, iPod?
How to split MPEG, MPG, SVCD, DVD, VCD?
How to play DVD movie on my PC step by step?
How to copy DVD9 to DVD5/DVD9?
How to copy PS2 game, and burn PS2 game?
How to recover password for protected MS Backup files?
How to convert RA to MP3, RM to MP3?
How to convert DVD to WMV?
How to convert DVD to RM RMVB?
How to Convert DivX to iPod step by step?
How to convert DVD to AVI step by step?
How to Extract DVD audio tracks to MP3 step by step?
More Gudies:   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30

How to Copy Worksheet Data to a Word Document?

There may be times when you want to present your Microsoft Office Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) data, in a Microsoft Office Word document. You can simply copy selected data in Excel and then use the Paste commands in Word to insert the data into a document.


Step by Step Tutorial - How to Copy Worksheet Data to a Word Document?

Step 1. In Excel, select the worksheet data that you want to copy to a Word document.

Step 2. On the Home tab, in the Clipboard group, click Copy

worksheet to word

Keyboard shortcut You can also press CTRL+C.

Step 3. In the Word document, click where you want to paste the copied worksheet data.

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

Keyboard shortcut You can also press CTRL+V.

Step 5. Click Paste Options next to the data, and then do one of the following:

  • To paste the data as a Word table, click Keep Source Formatting if you want to use the original format of the copied data, or click Match Destination Table Style if you want to use the document theme that is applied to the Word document.

  • To paste the data as a static picture, click Paste as Picture.

  • To paste a link to the Excel data so that the data in the Word document is updated when you change the original data in the Excel workbook, click Keep Source Formatting and Link to Excel or click Match Destination Table Style and Link to Excel.

  • To paste the data as text, with each row in a separate paragraph and with tab spaces separating the cell values, click Keep Text Only.

Notes

* If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button , and then click Word Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
* If you paste the data into a Word table, the Paste Options button displays different paste options. You can insert the copied data as a nested table, merge it with the existing table, insert it as new rows in the existing table, overwrite the cells in the existing table, or paste it as a static picture.


Tips

  • To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.

  • To edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. To provide access to the entire worksheet in the Word document, including data that you may want to keep private, click Microsoft Office Excel Worksheet Object.

  • To automatically update the table in the document when changes are made to the source data in Excel, click Paste link, and then select the option that you want in the As box. If you saved the source workbook before you copied the data, you can also click Word Hyperlink in the As box to insert a hyperlink in your document that directs you to the source data in Excel.

  • To paste the content as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) Word application icon (rather than pasting the actual content), click Microsoft Office Excel Worksheet Object, and then select the Display as icon check box. You can click the icon to open the application and then view the content.

  • To use HTML to copy the data to Word and display it in a Word table, click HTML format.

  • To paste a static picture, click Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).

  • To paste the data as formatted or unformatted text, click Formatted Text (RTF), Unformatted Text, or Unformatted Unicode Text.

  • To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.

  • If you want the range of data that you paste as a Microsoft Excel Worksheet Object into a Word document to expand when the corresponding data expands on the Excel worksheet, you can define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the range of data in Excel before you copy the data. You can then paste a link to the named range by using the Paste Special command. On the Home tab, in the Clipboard group, click the arrow on the Paste button, click Paste Special, and then click Paste link.



Related Software Step by Step Guides and Tutorials:

How to translate English word to Russian word?

How to Convert DOC to CD with AutoPlay Me for Word?

How to convert Excel XLS/RTF XLSument to Jpeg/Jpg/Tiff/Bmp/Eps/Ps file?

How to recover data from damaged or formatted disks?

How to convert Word Doc/RTF document to image (Jpeg/Jpg/Tiff/Bmp/Eps/Ps) file?

How to decrypt protected PDF files with PDF Password Recovery software?

How to Capture SWF Flash Files from Webpages with Infine Capture Flash?

Software Reviews
Convert DVD to iPhone

DRM Protected Music to MP3

Convert Between MOV & FLV

DVD to PSP Converter

FLAC to MP3 Converter

Image Editing tools

iPhone Video Converter

Find Your IP Address

MIDI Software

Mp3 Splitter

PDF Tools

PSP Video Converter

RM Media Converter

Transfer iPhone to Mac

Video Editting Programs

MP4 converter

Word Unscrambler Software

More Software Reviews...


Qweas Software Store
Media Player Codec Pack

Active ISO Burner

K-Lite Mega Codec Pack

GOM Media Player

ViVi DVD Player

DRM Protection Removal

RAR Expander for Mac

DRM Buster

ISO-DAX-CSO Converter

PowerPoint/PPT to Pdf

FLV Crunch for Mac

Facebook Friend Blaster

iMovie HD for Mac

Prometeus (MacCISO-DAX)

7-Zip for Mac

Batch PPT to PDF Converter

AnyToISO Converter For Mac

Free DVD ISO Burner

iSpring Free

More Software Guides...