Defining shaped print area to repeat on every page (Vertically inverted "L" shape in this particular instance)

KlayontKress

Board Regular
Joined
Jan 20, 2016
Messages
67
Office Version
  1. 2016
Platform
  1. Windows
To all,



I need to define a print are that will show on every page but I'm having difficulty because it's not just a row of column I need, it's specific cells.

The first page of this quote to a customer ranges from cells A1:J43. I need to repeat the data in Columns A:C (Print titles takes care of this) but also the data in Cells D1:H15. I know of no way to get this additional bit of data to carry over on ever sheet. I tried defining specific cells on row to repeat but that didn't work (life can't be that simple).

Does anyone know how to do this? I basically need a vertically Inverted L shaped print area to print on every page.


Data is below. Cells D16:H43 need to be dynamic and change with the data as it goes to the right across multiple columns (In this particular quote, the data extends to column CE but can go much further.

A
B
C
D
E
F
G
H
I
J
1
Logo here
2
3
To:
Date:
01/15/18
4
5
Job:
Plan:
6
7
This quotation includes the following:
8
9
1) ******* Cabinets and Bathroom Vanities per layouts provided by Enter Company Name Here.
10
2) NO applicable taxes.
11
3) Delivery and jobsite distribution.
12
4) Shipment of all lines and styles requires twenty (20) working days from date of order.
13
14
15
16
Group
Style
STANDARD *******
OPTION 194 120 REAR STAIRCASE
OPT 194 760 120 REAR STAIRCASE W CHEFS *******
OPT 501 SOLARIUM *******
OPT 501 194 120 SOLARIUM ******* W REAR STAIRCASE
OPT 529 NAPLES SUNROOM
OPT 529 194 120 NAPLES SUNROOM W REAR STAIRCASE
17
18
Base
Standard
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
19
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
20
Level 1
Level 1
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
21
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
22
Level 2
Level 2
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
23
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
24
Level 3
Level 3
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
25
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
26
Level 4
Level 4
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
$$$$$
27
28
29
Add LEVEL 1 HARDWARE
$$$$
$$$$
$$$$
$$$$
$$$$
$$$$
$$$$
30
Add LEVEL 2 HARDWARE
$$$$
$$$$
$$$$
$$$$
$$$$
$$$$
$$$$
31
Add 42in Refrig Deco Door Package
32
Add INSTALL NORTHEAST
$$$$$$
$$$$$$
$$$$$$
$$$$$$
$$$$$$
$$$$$$
$$$$$$
33
Add SOUTHEAST INSTALL
$$$$$$
$$$$$$
$$$$$$
$$$$$$
$$$$$$
$$$$$$
$$$$$$
34
Add Level 4 Base Cabs DSSK-TCCM8
35
36
37
38
Note: Prices include hardware
39
40
NOTES:
41
42
Sales Representative
43
Name here

<tbody>
</tbody>
 
Last edited:

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,214,918
Messages
6,122,257
Members
449,075
Latest member
staticfluids

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