Values more than one worksheet

W

Wanna Learn

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
 
D

Don Guillett

try right click sheet tab>select all sheets>do your thing>select any sheet
 
G

Gord Dibben

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 Special>Values>OK>Esc.

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


Gord Dibben MS Excel MVP
 
Top