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?
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?
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:
>
> 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?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks