Position of Pagehead and pagefoot

[nfpk]

Hi!

Does anyone know how to move the Pageheader to right or left?

For example, I have a Worksheet where I want a left margin, where I start the Pagehead exactly in line with the cells in the worksheet. Is this possible? I know I can use blanks in the header but thats not professional.....

nfpk

 

[guava65]

It sounds to me like you can use the page setup to make this work. Cehck out the "sheets tab" on the page set-up dialog. (see below)

TMake the column whatever width you'd like and dress it up with data or graphics. I hope this is what you're looking for.

Good luck. Mahalo,
cg

 

[nfpk]

Well, i can´t see how to make it..... maby I´m blind...

If I for some reasons want a larger left margin, I still can´t understand how I can move the pageheader... so that it follows the cells???

nfpk

 

[plantj]

I think you're out of luck on this one nfpk. The LeftMargin property, for instance, affects only the position of the cells. There doesn't appear to be a visible property for the Header or Footer's left margin. You may need to consider using the sheet's Print titles.

 

[IRstuff]

The page margins are shared between header/footer and the rest of the page.

However, if I understand you correctly, you should be able to simply copy the row that you want to match into the header and simply make the borders of the cells invisible.

 

[nfpk]

Thanks for advice, I think PlantJ is right on this..... there isn´t a way to move the header....