Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 347
Default Save worksheet as a word doc

How do I copy a single worksheet(sheet17) and save it as a word document and
place it in another file.
--
George
  #2   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why won't my formulas work until I save the worksheet? gwwillits Excel Worksheet Functions 3 February 5th 06 04:42 AM
Can't save Excell worksheet from email Donna T Excel Discussion (Misc queries) 2 January 28th 06 05:46 PM
How to save the current worksheet as JPEG, TIFF or DICOM? DORI Excel Worksheet Functions 2 November 23rd 05 06:51 AM
how do i create and save a new file or worksheet autmatically ever DAN Excel Discussion (Misc queries) 0 March 30th 05 03:07 PM
Inserting worksheet in Word Connie Martin Excel Discussion (Misc queries) 0 January 11th 05 06:19 PM


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"