On Aug 27, 2:46 pm, amergerm35
wrote:
I have an Excel workbook that is composed of the results from Access queries.
IE. 1 query is 1 worksheet. So far I have 31 in the workbook and will likely
have 50-75 before I'm finished.
How can I populate the formatting from the 1st sheet (header naming
convention, size, layout, etc.) to each one that is there now and as I add
more? Each added sheet defaults back to the Excel 2000-2003 format.

Thanks

Setup a template so each sheet will already be preformatted. You can
find instructions in Help under Templates. Would be an .xlt file.

To fix existing files, Select All, copy, goto all the other sheets you
want (Shift- or CTRL-click the tabs), goto cell A1, Paste
Special:Formats. You can do the same thing with a normal Paste if you
have to copy your actual column headers, assuming the data is always
in the exact same place.

You could also copy sheets (then delete the data) instead of using the
New:Sheet command. I generally Drag-n-Drop to do this, while holding
down CTRL. Unless the query process creates the sheet, then nevermind.