I have many Excel 2003 workbooks/worksheets. When I print them, I want certain printing specs to apply to EVERY sheet eg: narrowest margins [.25″], gridlines, centered footer in Ariel narrow, 8 pitch with filename+sheetname+date, print on one page, etc). Doing this manually for each sheet is a hugh time waster. Is there some other way to do this? ie a way to apply certain default print settings to a worksheet? Perhaps a macro?
