help

  • Thread starter Thread starter Ron Bird
  • Start date Start date
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
 
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.
 
And now get back to work--if your department is like mine, you've spent way to
much time on this already!
 
Ah, but the worksheet is protected (I forgot that).

Insert a new sheet and use a formula like:

='nameofsheet'!s1
and drag down.
 
Ron Bird said:
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
Click to expand...

Hi Ron,

There are DIY programs available for getting around the password
protection in MS Excel, if you would like to learn some simple
programming.

If this is just for fun, there are many simple tools available online
too. Try a search or click here:

http://www.intertek.org.uk

Please do not access anybody else's files unless you are authorizated
to do so.

Joe.
 
Back
Top