Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
I wish to put the same header on all sheets of a workbook. I have checked
the help resources but could not find anything. Can anyone help me. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
Try
Group all the sheets that you want similar header by pressing Shift and click on the sheets' tab Go to A1 and type in your header follow by other cells on the first row, assuming that you want your headers on the first row press Enter Deactivate Group sheets by clicking on one sheet The same header/s now appear in all sheets you have selected -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "lemorse" wrote: I wish to put the same header on all sheets of a workbook. I have checked the help resources but could not find anything. Can anyone help me. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
Right-click on a sheet tab and "Select all sheets"
Set up the header on active sheet and will be done to all. This can lead to some problems if you want other print settings different for each sheet. I would tend to use a macro so other print settings do not get altered. Sub AllHeaders() Dim WS As Worksheet For Each WS In ActiveWorkbook.Sheets WS.PageSetup.CenterHeader = "&""Algerian,Regular""&16" _ & "This is my header text" Next End Sub Gord Dibben MS Excel MVP On Sat, 19 Sep 2009 11:04:02 -0700, lemorse wrote: I wish to put the same header on all sheets of a workbook. I have checked the help resources but could not find anything. Can anyone help me. Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
Francis,
Thanks for the reply. I will try that but what I wanted was to use the headers and footers tab under View rather than an individual cell. Will your method work this way? I've got to try it. "Francis" wrote: Try Group all the sheets that you want similar header by pressing Shift and click on the sheets' tab Go to A1 and type in your header follow by other cells on the first row, assuming that you want your headers on the first row press Enter Deactivate Group sheets by clicking on one sheet The same header/s now appear in all sheets you have selected -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "lemorse" wrote: I wish to put the same header on all sheets of a workbook. I have checked the help resources but could not find anything. Can anyone help me. Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
Thank you to all that replied. I have tried the suggestions and they work
great. I am embarrassed that I couldn't figure it out myself. This is the first time I have used this forum, always used USENET before, and it has worked great. Thank you so much. "Gord Dibben" wrote: Right-click on a sheet tab and "Select all sheets" Set up the header on active sheet and will be done to all. This can lead to some problems if you want other print settings different for each sheet. I would tend to use a macro so other print settings do not get altered. Sub AllHeaders() Dim WS As Worksheet For Each WS In ActiveWorkbook.Sheets WS.PageSetup.CenterHeader = "&""Algerian,Regular""&16" _ & "This is my header text" Next End Sub Gord Dibben MS Excel MVP On Sat, 19 Sep 2009 11:04:02 -0700, lemorse wrote: I wish to put the same header on all sheets of a workbook. I have checked the help resources but could not find anything. Can anyone help me. Thanks in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
You can access the message/answers using either a web browser (forum), OR
with an email client by setiing up a newsgroup account. Many nof us find the latter to be more convenient. Set up new newsgoup account specifying: msnews.microsoft.com as the server best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "lemorse" wrote in message ... Thank you to all that replied. I have tried the suggestions and they work great. I am embarrassed that I couldn't figure it out myself. This is the first time I have used this forum, always used USENET before, and it has worked great. Thank you so much. "Gord Dibben" wrote: Right-click on a sheet tab and "Select all sheets" Set up the header on active sheet and will be done to all. This can lead to some problems if you want other print settings different for each sheet. I would tend to use a macro so other print settings do not get altered. Sub AllHeaders() Dim WS As Worksheet For Each WS In ActiveWorkbook.Sheets WS.PageSetup.CenterHeader = "&""Algerian,Regular""&16" _ & "This is my header text" Next End Sub Gord Dibben MS Excel MVP On Sat, 19 Sep 2009 11:04:02 -0700, lemorse wrote: I wish to put the same header on all sheets of a workbook. I have checked the help resources but could not find anything. Can anyone help me. Thanks in advance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
howto put the same header on all worksheets of workbook
Francis' method is used to replicate titles in row 1 across all sheets.
Not for Headers and Footers. Gord On Sat, 19 Sep 2009 11:48:01 -0700, lemorse wrote: Francis, Thanks for the reply. I will try that but what I wanted was to use the headers and footers tab under View rather than an individual cell. Will your method work this way? I've got to try it. "Francis" wrote: Try Group all the sheets that you want similar header by pressing Shift and click on the sheets' tab Go to A1 and type in your header follow by other cells on the first row, assuming that you want your headers on the first row press Enter Deactivate Group sheets by clicking on one sheet The same header/s now appear in all sheets you have selected -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "lemorse" wrote: I wish to put the same header on all sheets of a workbook. I have checked the help resources but could not find anything. Can anyone help me. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
different header for different worksheets? | Excel Discussion (Misc queries) | |||
Excel header how to automate for new worksheets | Setting up and Configuration of Excel | |||
i need to save the same header to use on all worksheets in a workb | Excel Discussion (Misc queries) | |||
Inserting the same header/footer on all worksheets in a workbook | Excel Discussion (Misc queries) | |||
One header for all worksheets in workbook | Excel Discussion (Misc queries) |