password protect

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Password Protect

resolvedResolved · Low Priority · Version 2007

Rosanne has attended:
Excel Intermediate course

Password Protect

Hi,
How do I password protect so that my spreadsheet will ask for the password to be able to edit or give them the option to read only?

thank you,

Rosie

RE: Password Protect

Hi Rosanne,

Thank you for your question.

There are two possible ways of achieiving this.

Firstly go to Tools, Protection and Protect sheet and assign a password.

Secondly, go to File, Save As and then look for the Tools menu. Select General options and then Password.

You can choose to create a password to open and/or modify or choose for Read Only recommended.

I hope this helps and answers your question.

Regards

Simon

RE: Password Protect

Hi Rosanne


I hope the response received to your question has helped.


If you require further assistance, please do reply to this post, otherwise your question will be marked as resolved within five days.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 23 Sep 2010: Automatically marked as resolved.


 

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips


Server loaded in 0.09 secs.