I have these headers..
<TABLE style="WIDTH: 1014pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1352 border=0 x:str><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 419pt; mso-width-source: userset; mso-width-alt: 20443" width=559><COL style="WIDTH: 105pt; mso-width-source: userset; mso-width-alt: 5120" width=140><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" span=2 width=87><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 89pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=119 height=21>Age Category</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=174>Parent Customer</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=74>Label #</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 419pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=559>Description</TD><TD class=xl50 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 105pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=140>Production Date</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 43pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=57>WHS</TD><TD class=xl42 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>Cases</TD><TD class=xl42 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 65pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=87>Pounds</TD><TD class=xl49 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 65pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=87>Disposition</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl45 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: navy" height=17>0-30</TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl51 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl43 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl43 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl47 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> </TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent">Big Boy</TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl52 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl44 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: gray"></TD><TD class=xl44 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: gray"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
The disposition is NOT part of the pivot table.
How Do I input a drop down box that is the exact shape of a cell so it looks correct?
<TABLE style="WIDTH: 1014pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1352 border=0 x:str><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 419pt; mso-width-source: userset; mso-width-alt: 20443" width=559><COL style="WIDTH: 105pt; mso-width-source: userset; mso-width-alt: 5120" width=140><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 2011" width=55><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" span=2 width=87><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 89pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=119 height=21>Age Category</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 131pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=174>Parent Customer</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=74>Label #</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 419pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=559>Description</TD><TD class=xl50 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 105pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=140>Production Date</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 43pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=57>WHS</TD><TD class=xl42 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 41pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=55>Cases</TD><TD class=xl42 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 65pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=87>Pounds</TD><TD class=xl49 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 65pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=87>Disposition</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl45 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: navy" height=17>0-30</TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl51 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl46 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl43 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"></TD><TD class=xl43 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: navy"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl47 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> </TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent">Big Boy</TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl52 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl48 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #993366 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl44 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: gray"></TD><TD class=xl44 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: gray"> </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
The disposition is NOT part of the pivot table.
How Do I input a drop down box that is the exact shape of a cell so it looks correct?