Coverpage automatically as frontpage when printing

Benner

New Member
Joined
Apr 23, 2018
Messages
1
Hi

I am trying to make a cover page with a picture filling the whole page. I would like the cover page to:
a) be automatically added as the first page, when printing a worksheet (report), and
b) have title and headlines automatically filled depending on which woorksheet/report I choose for printing.

Regarding a) : The workbook contains several worksheets, in which worksheet 1-5 are reports and the rest are standard information used in the formulars. When printing any sheet between 1-5 the same coverpage should automatically to be added.

Regarding b) : All worksheets (reports) contains the info which are needed on the Cover page. The info are in the same celles on each sheet etc. A1=Title, A2= Name of company and so forth.

I struggle with almost every bit of this task:
- How can I get the picture to fill a whole page with no margins on the print preview?
- How can I set the picture as a background, so I can use cells as the references to what need to be Title, headline and so on? And is this the best procedure?
- Getting it to print the cover page as the first page regardless of the worksheet I want to print.

Br. Thomas
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top