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]