Lindsay Duncan wrote:
I am open office calc 2.2
I have a silly problem that I can't seem to find the answer for in the
guide or online.
Every time I enter something into a cell it repeats the info into each
sheet I have associated in the file.  Can you tell me how to "turn off"
this feature??
Thank you!!
Lindsay Duncan


Linday: Let me make sure I understand the situation. You have a worksheet with three sheets in it, Sheet1, Sheet2, and Sheet3. You type something into cell A1 of Sheet1, and that same entry is made in cell A1 of Sheet2 and of Sheet3. That's how I read your question. Is that the situation?

If so, it would appear to me that you have all of the sheets selected (they would all have a white background, instead of a gray background).

If this is the case, it's not totally obvious how to deselect the sheets, so that there is only one sheet selected again. In Excel, all you need to do is click on any one of the sheets, and the sheet you click on will be selected, and the others deselected. It's not that simple in Calc.

If you have all of the sheets selected, and you want to deselect all but one, go to: Edit > Sheet > Select

Then click on the one sheet you want selected, and click OK.

If this is not the problem that you're having, then you need to write back (to [email protected]) and describe the problem more fully.

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

Reply via email to