Hi,

there is no automatic way to do this in any version of Excel. You might
write VBA code to do it or you can cut and paste each page manually. Maybe
someone has created an add in to do this but I am not aware of it.

If this is helpful, please click the Yes button.

Cheers,
Shane Devenshire

"ian_rrrr" wrote:

How can you convert multiple pages (from Page Break Preview) into multiple
worksheets?