How to Convert an Excel 2010 spreadsheet to a word document

This tutorial will show you how to convert and Excel spreadsheet into a Word document.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/103440382717658277879 - our group in Google+

Transferring spreadsheet data into Word is a valuable skill to know. This tutorial is going to show you how to convert an excel spreadsheet to a word document.

Step # 1 -- Copying the Data

There are two main ways to bring spreadsheet data into Word. The first option we will look at is to just to bring the data itself. Go to the Excel file with the data you want to copy. Highlight the information and right click on it and click "Copy".

Step # 2 -- Pasting Just the Data

Now go to Word and right click where you want to insert the information. You will be presented with several paste options such as whether you want to paste a picture or keep the source formatting. Here we will paste with source formatting.

Step # 3 -- Opening Paste Special Options

Simply pasting the data alone does have disadvantages. Here you can see if we change a price, the total does not adjust, as it would in the Excel file. To learn how to convert an excel spreadsheet to a word document with the formulas intact you have to "Paste Special". In the "Home" tab, located "Paste" and click the small arrow below this. Then click "Paste Special...".

Step # 4 -- Inserting a Worksheet Object

The "Paste Special" window will open. From the list of options select "Microsoft Excel Worksheet Object" and click "OK". The computer will load for a moment as the data is imported. Now if you double click on this sheet you will be able to edit the information as if it were in Excel.

---

Closed Caption:

transferring spreadsheet data into word
is a valuable skill to know this
tutorial is going to show you how to
convert an Excel spreadsheet to a word
document
there are two main ways to bring a
spreadsheet data into word
the first option we will look at is just
to bring the data itself
go to the excel file with the data you
want a copy
highlight the information and right
click on it and click copy
now go to word and right click where you
want to insert the information you will
be presented with several paste options
such as whether you want to paste a
picture or keep the source formatting
here we will paste with source
formatting simply pasting the data alone
does have its disadvantages
here you can see that if we change a
price the total does not adjust as it
word in the excel file to learn how to
convert an Excel spreadsheet to a word
document with the formulas intact
you have to paste special in the Home
tab locate paste and click the small
arrow below this then click paste
special the paste special window will
open from the list of options select
Microsoft Excel worksheet object and
click OK
the computer will load for a moment as
the data is imported now with you
double-click on this sheet you will be
able to edit the information as if it
were in Excel