Save only One Worksheet To Separate File

  • Thread starter Thread starter John Gregory
  • Start date Start date
J

John Gregory

I need to place into a Word document, only one of several worksheets in a
workbook. When I shade and save that worksheet, I get the entire workbook.

Can someone please point me in the direction for these instructions.
 
Hi

Right-click on sheet tab and select 'Move or copy'. Check 'Create a copy'
and in 'To book' field, select 'New Book'. OK
You get a single-sheet new workbook. Save it under a new name.
 
Hi John

As you have found, a .xls file can have many sheets and saving will
always save the entire Workbook.

The copy method, described above is probably waht you need. However,
push Ctr+A and then copy, will allow you paste into Word.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Email Worksheet Question 3
Open Worksheet 2
save worksheet to a seperate new file 7
How save worksheet 3
Searching for a text in different worksheets in a different workbook 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to transfer a worksheet into a new workbook and keep the formulas intact 5

Back
Top