Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Footes - Automaticly print on every print job - Excel 2007
Is there a way to set print options to always print a footer even on existing
files? I'd like to get the file name and location on every file I print without needing to tell it to do it. Excel 2007 Thanks John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Footes - Automaticly print on every print job - Excel 2007
You can't set new defaults on pre-existing files. However, what you could do
is setup a printing macro that sets up a footer with file name and location, and then prints file. Setup a shortcut key, (in your case, you might even want to use Ctrl+p) and then save the macro in your personal workbook (the one XL loads everytime). Now, everytime you load XL, that macro should get loaded, and you can use it to print pre-exisitng files with your desired footer. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JohnH" wrote: Is there a way to set print options to always print a footer even on existing files? I'd like to get the file name and location on every file I print without needing to tell it to do it. Excel 2007 Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel spreadsheet won't print or print preview all the pages? | Excel Worksheet Functions | |||
Print thru using EXCEL 2007 | New Users to Excel | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
Excel cell looks good in print preview but doesn't print??? | Excel Discussion (Misc queries) |