Multi-Sheet Page Setup

Here’s one more point for you on multiple sheet selection and editing before we finish off the week.  It is also possible, when multiple sheets are selected, to change many of the Page Setup options for the sheets all at the same time.  For instance, if you go into File/Page Setup in Excel 2003 or into Page Layout/Print Titles in Excel 2007, you could switch to the Page tab and change all of the sheets to Landscape format at the same time.  You could also change the paper to Legal.

On the Margins tab, you could change the margins for all of the sheets at once.  Likewise, on the Header/Footer tab, you could set the same headers and footers for each and every sheet.  On the Sheet tab, you could use any of the options in the lower half of that tab.  However, the only Page Setup features you can’t set with multiple sheets selected are setting the print area for each sheet and specifying which rows to repeat at the top of each page.  This kind of makes sense, from the perspective that if you do happen to have different information on each of the sheets, it might take up a different number of rows and columns on each one.  However, when you think about how much freedom you have to accidentally type over other cells, you’d think that would be more of a risk than accidentally not printing a certain piece of one sheet.  Maybe that’s just my view, though.  :>

Have a great weekend!