You could also select multiple sheets, CTRL-A to select all, CTRL-C to copy,
then ALT, E,S,V to paste special values to overwrite all of your formulas.
Just be sure to save the file under a different name.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Dmag" wrote:

I have a workbook with several tabs all with formulas. When I Distribute I
like to eliminate the formulas so I copy & paste the values. It just takes a
while since I have to do it for several tabs. Any way to do this for the
workbook in one shot?