View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amergerm35 amergerm35 is offline
external usenet poster
 
Posts: 3
Default how do I apply formatting from one worksheet to a whole workbook?

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