Splitting a workbook's sheets into seperate files

Just to add to Roger's response.

If you open just that file that you want to work with, you can use:
window|arrange|tiled
(make it kind of small so you can see the desktop surrounding that window)

You can ctrl-click and drag each sheet to that desktop area.

Then you can save each of these new workbooks with new names.

(I'd only open the single file--just to reduce the clutter--not for any
technical reason.)

Roger Govier wrote:
>
> Hi
>
> Right click on the Sheet tab>Move or Copy>Select New Workbook>click the Copy
> box.
> Save the new workbook as whatever filename you want.
> Repeat for each sheet in existing workbook.
>
> Regards
>
> Roger Govier
>
> Turnipboy wrote:
> > I have a workbook with several spreadsheets in it, how do I quickly
> > seperate these sheets into seperate files.
> >
> >

--

Dave Peterson

And I mean Excel's desktop--not the windows desktop (if that wasn't clear).

Dave Peterson wrote:
>
> Just to add to Roger's response.
>
> If you open just that file that you want to work with, you can use:
> window|arrange|tiled
> (make it kind of small so you can see the desktop surrounding that window)
>
> You can ctrl-click and drag each sheet to that desktop area.
>
> Then you can save each of these new workbooks with new names.
>
> (I'd only open the single file--just to reduce the clutter--not for any
> technical reason.)
>
> Roger Govier wrote:
> >
> > Hi
> >
> > Right click on the Sheet tab>Move or Copy>Select New Workbook>click the Copy
> > box.
> > Save the new workbook as whatever filename you want.
> > Repeat for each sheet in existing workbook.
> >
> > Regards
> >
> > Roger Govier
> >
> > Turnipboy wrote:
> > > I have a workbook with several spreadsheets in it, how do I quickly
> > > seperate these sheets into seperate files.
> > >
> > >
>
> --
>
> Dave Peterson

--

Dave Peterson