Copy entire work book

  • Thread starter Thread starter Daniel Louwrens
  • Start date Start date
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
 
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
 
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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
email a worksheet 1
I can only delete an entire row not a cell in excel 2013? 1
Cant print multiple copies of a worksheet 2
Name an Entire Workbook 3
can I change page layout in an entire existing Excel workbook? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Merge Multiple workbook sheets into one workbook 0

Back
Top