software

I am creating a quot;padquot; 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?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.

nigelb wrote:
gt;
gt; I am creating a quot;padquot; of workbooks with individual name for each workbook.
gt;
gt; I want to quickly insert the name as a custom header but have to go into
gt; each individual sheet, is there a quicker way?

--

Dave Peterson