rich_cirillo
Board Regular
- Joined
- Sep 26, 2012
- Messages
- 247
Hi
I have 7 documents in a worksheet.Each document range is A5:AB34 for document 1 , Document2 range is A36:AB65 etc..etc ...A 2 row gap between each document...How can i set a print area for each document ( 1 to 7 )....Can print areas named Document 1,Document 2 , Document 3 etc..etc... be saved into the "Name Box" so i can then just select which document to print from the Name Box?
Also is there a way to have a watermark on each document (each sheet has a watermark say document 1,document 2 ,document 3 etc..etc..) but when each document gets printed it does not show the watermark on the printed sheet
Thanks for any help
Rich
XL2010
I have 7 documents in a worksheet.Each document range is A5:AB34 for document 1 , Document2 range is A36:AB65 etc..etc ...A 2 row gap between each document...How can i set a print area for each document ( 1 to 7 )....Can print areas named Document 1,Document 2 , Document 3 etc..etc... be saved into the "Name Box" so i can then just select which document to print from the Name Box?
Also is there a way to have a watermark on each document (each sheet has a watermark say document 1,document 2 ,document 3 etc..etc..) but when each document gets printed it does not show the watermark on the printed sheet
Thanks for any help
Rich
XL2010