Saving a single worksheet

  • Thread starter Thread starter Debra Carner
  • Start date Start date
D

Debra Carner

Is there a way to save a single worksheet instead of all
worksheets in the workbook? For instance, I have several
sheets in one workbook and want to save only one of the
sheets to a floppy in drive A. I know I can move or copy
to a new book and then save, but is that the only way or
is there an easier way?

Please help - thanks
 
Debra,

What you are doing - moving or copying to a new workbook and then saving - is the best method. Writing a macro to do that for you
would be easier, but won't save you that much time/effort.

HTH,
Bernie
Excel MVP
 
Delete all sheets except the one you want and "Save As" under a new name. Be
careful here. You MUST use File>Saveas, NOT Save.

To delete sheets, you can CRTL + Click on each to select or if contiguous,
select first in line then SHIFT + Click on last.

A word of caution here............not good practice to save directly to a
floppy. Data can be lost or file becomes unreadable/corrupt. Best to save to
HDD then copy to the floppy.

Same for opening from a floppy. Copy to HDD first then open.

The saving of one sheet to a new book can be automated using VBA code.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top