Reszie Header boxes

[Rob K]

Hi there,

Is there a way to resizes the three boxes in the header? The sheet I am trying to copy requires a wide first column, but I need to split up the box for the Title however, i don't want to merge any cells and splitting them up can't be done, but if the Header boxes can be adjusted to two boxes 1/4 page width and the last box 1/2 page width, that would be excellent.

Any help on this would be much appreciated.

Kind regards
Rob

[newdoverman]

There is nothing that you can do about the widths of the header and footer boxes. They are fixed in width but you can have text exceeding the dimensions of the boxes even to the point of having text on top of text. The left box is left justified, the centre box is centered and the right box is right justified.

Take a look at this thread on headers that is currently going on in Excel Forum it may give you some insight into solutions for your particular problem or lack thereof.
http://www.excelforum.com/excel-gene...in-header.html