Right-click on any sheet tab and "select all sheets".

CTRL + a(twice in 2003) on active sheet to select all cells.

CopyPaste SpecialValuesOKEsc.

Ungroup the sheets by selecting any sheet but the active one or right-click and
"Ungroup sheets".


Gord Dibben MS Excel MVP

On 31 May 2007 11:34:43 -0700, cass calculator wrote:

how would you copy and paste the values for all sheets in a workbook?

Thanks,

Joshua