Save a worksheet only!!!

I have a large workbook, of which I want to save 1 worksheet as a seperate file.

How do i do that? everything that i do saves the entire workbook. not interested in that. just need to save the 1 sheet.

thanks for the help folks

[Barrie Davidson]

On 2002-02-18 10:59, Anonymous wrote:
I have a large workbook, of which I want to save 1 worksheet as a seperate file.

How do i do that? everything that i do saves the entire workbook. not interested in that. just need to save the 1 sheet.

thanks for the help folks

Right click on the worksheet, select MoveorCopy, select "Create a Copy", and select (new book) in the "To Book" field. Now save that new book using whatever file name you desire.

_________________

Barrie Davidson
My Excel Web Page

[ This Message was edited by: Barrie Davidson on 2002-02-18 11:02 ]