Windows Forum

Ask something
Discussion Locked

UNPROTECTING A WORK SHEET IN EXCEL

0 helpful
3 replies

by ashishshekhar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I HAVE COME ACROSS AN EXCEL SHEET WHICH HAS SOME INTERESTING FUNCTIONS ON CELLS.
THE ENTIRE SHEET IS PROTECTED WITH A PASSWORD I DO NOT KNOW.
HOW DO I UNPROTECT SOMEONE ELSES WORKSHEET ??

3 replies

by ctr2000

Try this:
You can copy all the data by selecting all the cells (CTRL A), then paste it into a new worksheet. And the new worksheet won't be protected.

This discussion is closed to new replies.