Excel formatting

[superdave1984]

Is there anyw ay to format several Excel spreadsheets at the same time? I have over 100 that all need to be in the same format, page size, etc. They are existing sheets that need to be changed. Doing this to every one is a pain. Any suggestions?

 

[Inaris]

how about a macro that does it for you? create a macro that you can load the run on each one. I don't think there is a way to do it for all at once, but that would take out the pain of repetition... at least a little...