Values more than one worksheet
 

Hello I have a workbook with 32 worksheets. Before I send out the report I
copy- paste special -values each sheet. Is there a faster way to do this.
thanks

Values more than one worksheet
 

try right click sheet tabselect all sheetsdo your thingselect any sheet

--
Don Guillett
SalesAid Software

"Wanna Learn" wrote in message
...
Hello I have a workbook with 32 worksheets. Before I send out the report
I
copy- paste special -values each sheet. Is there a faster way to do this.
thanks

Values more than one worksheet
 

Right-click on a sheet tab and "select all sheets"

In activesheet hit CTRL + a(twice in 2003) to select all cells.

Copy then Paste SpecialValuesOKEsc.

Right-click on a sheet tab and "ungroup sheets".


Gord Dibben MS Excel MVP

On Mon, 4 Jun 2007 05:20:00 -0700, Wanna Learn
wrote:

Hello I have a workbook with 32 worksheets. Before I send out the report I
copy- paste special -values each sheet. Is there a faster way to do this.
thanks