| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Display Header/Footer in View
I am trying to display at least the header in an excell spreadsheet when
viewing the worksheet (I want the view to look the same as the printed version). Please help! Thanks cjaaron |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Display Header/Footer in View
You need to use File/Print Preview
Bob Umlas, Excel MVP "cjaaron" wrote: I am trying to display at least the header in an excell spreadsheet when viewing the worksheet (I want the view to look the same as the printed version). Please help! Thanks cjaaron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Display Header/Footer in View
Thanks Bob, I am aware of File/Print Preview but I was looking for a way to
display the logo's that I have placed in the Header when opening this spreadsheet - not everyone will print this file or display it in print preview...any suggestions?? Agan TIA for your help! cjaaron "Bob Umlas, Excel MVP" wrote: You need to use File/Print Preview Bob Umlas, Excel MVP "cjaaron" wrote: I am trying to display at least the header in an excell spreadsheet when viewing the worksheet (I want the view to look the same as the printed version). Please help! Thanks cjaaron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Display Header/Footer in View
Can easily be done as you wish in the upcoming Excel 2007. Meanwhile, you can
force the user into a print preview when the workbook opens by this code (right-click the excel LOGO near the file menu & select View Code & paste this in: Private Sub Workbook_Open() Me.PrintPreview End Sub "cjaaron" wrote: Thanks Bob, I am aware of File/Print Preview but I was looking for a way to display the logo's that I have placed in the Header when opening this spreadsheet - not everyone will print this file or display it in print preview...any suggestions?? Agan TIA for your help! cjaaron "Bob Umlas, Excel MVP" wrote: You need to use File/Print Preview Bob Umlas, Excel MVP "cjaaron" wrote: I am trying to display at least the header in an excell spreadsheet when viewing the worksheet (I want the view to look the same as the printed version). Please help! Thanks cjaaron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Display Header/Footer in View
A WHOO HOO goes out to you Bob - Yes that seems to be working!!!
cjaaron "Bob Umlas, Excel MVP" wrote: Can easily be done as you wish in the upcoming Excel 2007. Meanwhile, you can force the user into a print preview when the workbook opens by this code (right-click the excel LOGO near the file menu & select View Code & paste this in: Private Sub Workbook_Open() Me.PrintPreview End Sub "cjaaron" wrote: Thanks Bob, I am aware of File/Print Preview but I was looking for a way to display the logo's that I have placed in the Header when opening this spreadsheet - not everyone will print this file or display it in print preview...any suggestions?? Agan TIA for your help! cjaaron "Bob Umlas, Excel MVP" wrote: You need to use File/Print Preview Bob Umlas, Excel MVP "cjaaron" wrote: I am trying to display at least the header in an excell spreadsheet when viewing the worksheet (I want the view to look the same as the printed version). Please help! Thanks cjaaron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
| Custom View Dialog Box | Excel Discussion (Misc queries) | |||
| Search and Display Formula | Excel Discussion (Misc queries) | |||
| I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
| My view has changed, I want same view as when opening excel | Excel Worksheet Functions | |||
Hybrid Mode
