select all, copy, right-click sheet tab and "select all sheets", select upper
left cell of whatever sheet you're on, alt-e, S, F, enter. Then again alt-e,
S, T, enter.

What you'll do is copy the entire first sheet, then tell Excel that what
you're about to do, it should do in the exact same way to all sheets. Then
you'll be special pasting first the formulae, then the formats, into all
sheets.
--
Boris


"BillFitz" wrote:

How to Copy formats and formulae from 1 worksheet to all worksheets in an
Excel file