excel intermadiate

AI Training: For Busy Decision Makers & Professionals Book now

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

Excel intermadiate

resolvedResolved · Medium Priority · Version 2003

Excel intermadiate

How do I protect cells on a sheet?

Many Thanks
Aimee

RE: excel intermadiate

Hello Aimee

Thank you for your question and welcome to the forum.

You can apply protection to a spreadsheet using Tools - Protection - Protect Sheet. You can set a password if you wish; also you can check (tick) the actions that you want to allow people using the spreadsheet to be able to perform even when protection is applied.

I hope this helps.

Kind regards
Amanda

Tue 25 Aug 2009: Automatically marked as resolved.


 

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips


Server loaded in 0.13 secs.