View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Save worksheet as a word doc

One way is to select all of the cells with data in them and use Edit | Copy
and then go to a Word document and Edit | Paste into it. This will result in
a table being created in the Word document with the data in it.

Another option would be to save the sheet as a formatted text file (.prn
type) and then use Word to open that file (have to browse using show all file
types option). An option close to this would be to save it as one of the
..txt types (tab delimited for instance) and then open that with Word and save
back out as a .doc file.

Similarly, you could save as .csv file and actually open that with Word - it
will look ugly, but the data will be there.

"George" wrote:

How do I copy a single worksheet(sheet17) and save it as a word document and
place it in another file.
--
George