Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default How do I repeat same custom header for entire workbook

I am trying to repeat the same custom header in every worksheet of my
workbook which is scanned in logo but at the moment I have to set it up for
every worksheet- Is there anyway it can be repeated automatically on every
worksheet in ther book
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I repeat same custom header for entire workbook

Try grouping the worksheets first.

Click on the first tab and ctrl-click on subsequent tabs (or right click on any
and choose Select all sheets).

Then do the page setup. Lots of these settings will be applied to all the
sheets that are grouped.

Be careful. Make sure you ungroup the sheets when you're done. Almost all the
changes you make to a grouped sheet will affect the other sheets in that group.

JillyB wrote:

I am trying to repeat the same custom header in every worksheet of my
workbook which is scanned in logo but at the moment I have to set it up for
every worksheet- Is there anyway it can be repeated automatically on every
worksheet in ther book


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One workbook to another . . . Wayne Knazek Excel Discussion (Misc queries) 2 September 26th 06 08:49 PM
How can I using Excel custom document properties in the header? ecalvo Excel Worksheet Functions 4 November 3rd 05 09:29 PM
custom header Marlis Excel Discussion (Misc queries) 5 August 26th 05 01:28 PM
Custom List Header GeyserPeak Excel Discussion (Misc queries) 2 July 8th 05 04:27 PM
One header for all worksheets in workbook WillieR Excel Discussion (Misc queries) 2 December 1st 04 09:27 AM


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"