Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page Header concern
Greetings (I'm not sure this is posted to the right forum)
a) How do I put the contents of a cell into the header? (will vary from worksheet to worksheet) b) I'm sure I'm missing something obvious, but where do I set the LEFT and RIGHT header margins? (I can only find top and bottom) I'd like them to be the same as the L and R margins for printing the main body of the document. Thank you Bri |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page Header concern
You can't put the contents of a cell in a header or footer, but you can put
the Tab name in a header or footer. File, Page setup, Heder/Footer, Custom header - there should be a button for the tab name, or you type in "&[Tab]" (without the quotes). Maybe by naming your tabs appropriatly, you could make this work for you. Left and right margins are on the same Page setup tab as the top and bottom margins. Different version of Excel look slightly different on the page setup dialog box so it's hard to describe what it should look like. -- George "Bri" wrote: Greetings (I'm not sure this is posted to the right forum) a) How do I put the contents of a cell into the header? (will vary from worksheet to worksheet) b) I'm sure I'm missing something obvious, but where do I set the LEFT and RIGHT header margins? (I can only find top and bottom) I'd like them to be the same as the L and R margins for printing the main body of the document. Thank you Bri |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page Header concern
Bri Wrote: Greetings (I'm not sure this is posted to the right forum) a) How do I put the contents of a cell into the header? (will vary from worksheet to worksheet) b) I'm sure I'm missing something obvious, but where do I set the LEFT and RIGHT header margins? (I can only find top and bottom) I'd like them to be the same as the L and R margins for printing the main body of the document. Thank you BriHi Bri, For question A: If your interested in doing it by code, this will take whatever is in cell A3 on each sheet and put it into the header on that sheet. You can change for your needs. Will work for veiwing or printing. The code must go into the "Workbook" module. Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = ActiveSheet.Range("A3").Value End Sub You can use .LeftHeader or .CenterHeader or .RightHeader .LeftFooter or .CenterFooter or .RightFooter -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=506005 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Page Header concern
YES, thank you
Bri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
How do I keep the header on the first page but hide it on the sec. | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |