Formatting

[Val]

I have multiple tabs (spreadsheets) set up in one file. I'd like to have
each one formatted to print the same (i.e. tab name, landscape layout, etc.).
Is there an easier way to format each tab without doing it individually?

 

[Paul]

Val,

You should be able to select the first tab then Shift + click to select all
of the tabs in a range, then format them all at once. There maybe an easier
way, but that is what I do.

Thanks,

-- Paul

 

[Val]

Paul,

Thanks for the response. I'm unable to set up for "Rows to Repeat at Top"
across all spreadsheets (it's greyed out). Anyone know if this is possible?

 

[Gord Dibben]

Setting Rows to Repeat at Top is not possible with grouped sheets.

Also print range cannot be set on grouped sheets.

You would have to loop through the sheets using VBA to get those set.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP