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 a Word Table into Excel?

When you want to move data from a Microsoft Office Word table to Microsoft Office Excel, you can avoid having to retype that data by copying it from Word directly into Excel. When you copy data from a Word table into an 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.), the data in each Word table cell is pasted in an individual cell on the worksheet.

After pasting the data, you may have to clean it up so that you can take advantage of the calculation features in Excel. For example, there may be unwanted extra spacing in cells, numbers may have been pasted as text rather than as numeric values that you can calculate, or dates are not displayed correctly.

Step by Step Tutorial - How to Copy a Word Table into Excel ?

Step 1. In a Word document, select the rows and columns of the table that you want to copy to an Excel worksheet.

Step 2. To copy the selection, press CTRL+C.

Step 3. In the Excel worksheet, select the upper-left corner of the worksheet area where you want to paste the Word table.

Note: Make sure that the paste area is empty before you paste the data. Data in Word table cells will replace any existing data in worksheet cells in the paste area. If necessary, review the table first in Word to verify its dimensions.

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

worksheet to word

Keyboard shortcut You can also press CTRL+C.

Step 5. To adjust the formatting, click Paste Options next to the data that you pasted, and then do the following:

  • To use the formatting that is applied to the worksheet cells, click Match Destination Formatting.
  • To use the formatting of the Word table, click Keep Source Formatting.


*Excel pastes the contents of each Word table cell into a single cell. After you paste the data, you can distribute the data across additional cells in a column (for example, to divide first and last names so that they appear in separate cells) by using the Text to Columns command (Data tab, Data Tools group).

Related Software Step by Step Guides and Tutorials:

How to recover lost deleted excel file?

How to convert DOCX to DOC with DOCX to DOC converter?

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

How to convert PowerPoint PPT to Jpeg, Tiff, BMP Image?

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

How to convert Text to PDF Document?

How to convert PPT to PDF, PPT to DVD, PPT to AVI with PPT converter?

How to convert CSV to PDF, HTML, DBF, XLS, DOC, MDB, XML, VCS, CHM, RTF, HLP?

How to convert PPTX to PPT with PPTX to PPT converter software?

How to open an XLSX File?
Software Reviews
Farm Town Cheats

FarmVille Cheat Engine

DPG & DPG2 converter

Watch Blu-ray on PC

XviD Player & XviD Codec

iTunes DRM Removal

WMV Player & WMV Codec

DivX Player & DivX Codec

PPT & PPTX Viewer

ISO to AVI Converter

VOB Players & Codecs

RMVB Player & Codec

MOV Player & MOV Codec

Convert XLSX to XLS

MKV Player & MKV codec

Mobile Flash player

AVI Players & AVI Codecs

ICO Converter

TS Player & TS Codec

HD DVD Player

More Software Reviews...