I tried both of these and no success. I'm going to try writing some VB code
for Access and try to force it that way.

Thanks,
Bill

"Valerie" wrote:

Copy one of your formatted sheets to a new book. File/Save As "Sheet.xlt"
(file type template). This automatically opens your template folder, but you
need to locate your XLSTART folder and put this file in it. When you create a
new sheet, it should pull from this template.

"Spiky" wrote:

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.