Is there a way to apply "page setup" defaults to an existing workbook in
Excel? For instance, I frequently work with excel files that someone else
has generated, and in order for me to print them out, I have to go to "page
setup" and change the margins to .5 on each side, and I like to have the
footer = pathname & file, and generally like to set my pages to fit on 1 page
width & height. Is there an "easy" way to apply a default page set up format
to existing files (and worksheets in the files) that have data in them? Or do
I just have to change every worksheet in every file one by one?