We can hide Formula in MS Excel sheet by
[1] FORMAT – CELL- PROTECTION -Tick LOCKED + HIDDEN then
[2] TOOLS -PROTECTION -PROTECT SHEET.

But, by using above, there are many restrictions in it. Can not copy or paste same row data in new row.

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

Suppose that we are using 1st Column for 1st day data of month and 2nd coloumn for 2nd day data, which were filled by our staff in a Excel Sheet day by day. so I want that all coulumn protected automaticly in a sequence after each 24 Hour. sothat our staff can not change the data of previous day.

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

In MS Excel, Sheet 3 is linked with sheet1. If i add or delete any row in sheet 1, the formula is getting changed accordingly. I want to fix the formula regardless of any changes in sheet1.

I have tried protect sheet, lock cell, hide cell, and using $ sign against the formula. But none of them is working. Please help!!!

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I got an e-mail from my cousin with a spreadsheet that is password protected. To figure out the password you have to solve the puzzle.

This is a 5th grade math problem. If you can open the spreadsheet, you’ll see it’s a very small list of people who have gotten the correct number. This is not a trick question. This is a real math problem so don’t say that a bus has no legs.

There are 7 girls in a bus. Each girl has 7 backpacks. In each backpack, there are 7 big cats. For every big cat there are 7 little cats.

The bus driver is not in the bus at this time.

Question:

How many legs are there in the bus? (The number of legs is the password to unlock the Excel sheet. If you open it, add your name, save it, and then send it on to see who else can unlock it.)

I can’t figure it out. Can you?

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I got an e-mail from my cousin with a spreadsheet that is password protected. To figure out the password you have to solve the puzzle.

This is a 5th grade math problem. If you can open the spreadsheet, you’ll see it’s a very small list of people who have gotten the correct number. This is not a trick question. This is a real math problem so don’t say that a bus has no legs.

There are 7 girls in a bus. Each girl has 7 backpacks. In each backpack, there are 7 big cats. For every big cat there are 7 little cats.

The bus driver is not in the bus at this time.

Question:

How many legs are there in the bus? (The number of legs is the password to unlock the Excel sheet. If you open it, add your name, save it, and then send it on to see who else can unlock it.)

I can’t figure it out. Can you?
Thanks. I tried it exactly that way, but I don’t have a calculator on me and I guess my math isn’t that great, lol.

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software