In a large multi tabbed workbook, we want to convert all formulas to values
before circulating outside our company.

We know about Copy-Paste Special-Values, but this seems to change formatting
(shadow, colors, etc.) no matter which boxes we check in Paste Special.

Is there any way quickly to convert all formulas to values while not
touching the formatting.

Also, how do you quickly select all cells in a multi tabbed workbook to make
this the range for your copying?

Tx for all help.