Becky Philip wrote:
I am using openoffice version 2.0. I am trying to create spread sheets with 
different headings. When I enter a header on one spreadsheet it copies to all 
the the sheets in that file. Is there a way to change this
Thank you
Becky

Yes, there is a way. You need to use page styles to do this.

I suggest reading the following chapter, titled "Using Styles in Calc":
http://documentation.openoffice.org/manuals/oooauthors2/0310CG-UsingStylesinCalc.pdf
for a description of how styles are used in Calc.

Basically, you define a separate page style for each sheet that you want different headers. It is very fast and easy to do.

Let's say you have two sheets, Sheet1 and Sheet2, and you want them to have different headers. You create two page styles, naming them Sheet1 and Sheet2 in this example. When you create each style, you can specify whether you want the header to be displayed, and what the contents of the header are. (You didn't ask, but you can also specify one page style to print in landscape, and the other in portrait -- which is a question that is asked from time to time.)

Then you make Sheet1 the active sheet and apply the style named Sheet1 to it.

Next make Sheet2 the active sheet and apply the style names Sheet2 to it.

I just went through this process to verify that it works, and it does indeed work, and it didn't take very long at all.

Again, please read the chapter, which will be much more helpful than my very quick explanation above.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to