Excel Print Setup Tips

I'll just comment on all your formatting posts, shall I. #theraputicformatting

1. Format one sheet the way you'd like it re: headers and footers. Then, while on that sheet, hold down shift and select the other sheets you'd like to make consistent. Hit Alt + P S P then Enter. Should apply all print settings (not just the Header and Footers) from the first-selected sheet.
2. This one is simpler. First, ensure formatting (font sizes, etc.) is consistent across sheets. Find the sheet with the widest content on it. Scale your print area to fit all columns. Then, click the dropdown box and hit Custom Scaling Options. There's an option (unchecked at the moment) that says Adjust to x% Normal Size. Have all sheet Custom Scaled to that % and everything should print consistently-sized.
3. This is more of a manual process, unfortunately. However, if you start by setting your print area with Alt P R S and then Alt W I to figure out what you're viewing, you can manipulate it pretty easily to have it print properly. Sometimes you're going to have to adjust print ranges for title rows at the bottom of pages, etc., but such is life. There are macros that can fix this, I believe, but I've never used them. Maybe someone else will be able to help.