Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password

Password

ResolvedVersion Standard

Thu 6 Mar 2008, 15:51 Delegate Cyril said...

Cyril has attended:
Excel Intermediate course

Password

How can I protect a whole spead sheet?

Mon 10 Mar 2008, 00:40 Trainer Mara said...

RE: Password

Hello Cyril,
I hope you enjoyed your Excel training session with us.

Thank you for your question to our forum. I have actually found the answer amongst our other forum questions:
https://www.stl-training.co.uk/post-2469-protecting-sheet.html

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Password

Password

RE: Password

Excel articles

Excel tip:

Hide data in Excel Worksheets