I am attempting to copy values using copy/paste. I copy a value in one cell and try to paste it to another cell. When I apply the paste nothing is put in the designated cell. I have attempted to copy titles such as "Date", "Amount" as well and they were not pasted. These titles were in the darkened title bar at the top of the spreadsheet.
I opened a new spreadsheet as a test and found that the copy/paste technique works on it. I entered a number, then copied it, and pasted it to another cell. Why does this work on one spreadsheet and not the other? Have I turned something off or on which prevents this from working on the spreadsheet? Is there a preference that is involved?
I am running Snow Leopard on an iMac. I am using Numbers 09.
I posted this question on the Apple Discussion web site but got no satisfactory answer. Hope you all can help.