Copy entire work book

D

Daniel Louwrens

I am using XL2000 SP3, and I need to copy an entire workbook of 96
worksheets, but with values only.
Is there some way to do this all at once.

thanks

Daniel
 
A

Andy Brown

Is there some way to do this all at once.

Couldn't you just group all the sheets? Then select all (CTRL+A)? Then copy
& paste special (values)? And Save As?

HTH,
Andy
 
D

Daniel Louwrens

Andy Brown said:
Couldn't you just group all the sheets? Then select all (CTRL+A)? Then copy
& paste special (values)? And Save As?

HTH,
Andy
Click to expand...
Thanks Andy, but how do I group all the sheets?

thanks

Daniel
 
A

Andy Brown

how do I group all the sheets?

Click the first sheet tab. Scroll to the last tab and click it *while
holding down Shift*.

Rgds,
Andy
 
A

Andy Brown

Not sure if this is version-specific, but in 2K you can rightclick a tab &
"select all sheets".

Rgds,
Andy

On the stereo this week ; Albinoni, Samuel Barber, Nirvana, Sinead O'Connor.
 
Top