help

R

Ron Bird

I have been sent a quiz sheet published in Excel, its a few pictures of
films with the faces missing, and you have to guess the film titles. It's
been driving me mad, i have been at it for days. The sheet itself has
password protection, is there a way around this , please help me save my
sanity, i need to cheat.

TIA
 
D

Dave Peterson

If I recall, the answers are in column S.

So in T1, put =S1
and drag down.

If you look at the formula that gives you the right/wrong response, you can see
the address of the cell that contains the answer.
 
D

Dave Peterson

And now get back to work--if your department is like mine, you've spent way to
much time on this already!
 
D

Dave Peterson

Ah, but the worksheet is protected (I forgot that).

Insert a new sheet and use a formula like:

='nameofsheet'!s1
and drag down.
 
Top