insert the same header in every sheet in a excel workbook

N

nigelb

I am creating a "pad" of workbooks with individual name for each workbook.

I want to quickly insert the name as a custom header but have to go into
each individual sheet, is there a quicker way?
 
D

Dave Peterson

You can get all the worksheets in a single workbook by grouping them.

Click on the first worksheet tab and ctrl-click on subsequent.

File|page setup
change your stuff

And ungroup the sheets. Almost anything you do to a sheet in a group gets done
to the other sheets in that grouping--sometimes nice, but often disastrous.
 
Top