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 *****
 
Back
Top