KG

Is the Sheet2 protected and some cells locked for selection?

Check out ToolsProtection. Is Unprotect Sheet available for selection?

If so, click on it. You may have to supply a password.


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 11:59:03 -0800, "KG" wrote:

when I am on Sheet2!A1 and I try to enter a formula such as =Sheet1!C4, I
find that I cannot point directly to Sheet1!C4; I need to go around and
around until I find the first cell in Sheet1 that will accept the cursor; and
then I can finally land on C4 by using the keyboard arrows. What causes that
and how can I prevent it?