sharing folders

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sharing folders

Sharing folders

resolvedResolved · Low Priority · Version 2003

Sacha has attended:
Excel Introduction course

Sharing folders

How do you allow others to read but not change data?

RE: sharing folders

Hi Sacha,

Thank you for your question.

Do you mean how do you protect a spreadsheet?

If so, you need to go to Tools and then Protection, Protect Sheet. Choose a password type it in and click OK and then re-enter the password to confirm. When anyone opens the file, only the people who know the password can edit anything.

If you need to edit the spreadsheet, you need to go to Tools, Protection and Unprotect Sheet. Type your password in and you can edit the sheet.

Don't forget the password though.

I hope this answers your question.

Regards

Simon

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips


Server loaded in 0.08 secs.