View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Add footers in 20 worksheets at once

Ron

That would also force each sheet to have the other print charateristics of the
active sheet thus changing orientation and the custom headers on each sheet.


Gord

On Thu, 14 Jun 2007 18:09:14 +0200, "Ron de Bruin"
wrote:

Group all sheets Nick

Right click on a sheet tab and choose Select all sheets
Then change the footer
And then ungroup the sheets