excel intermadiate
Courses running during train strike
Hide

TrustPilot

starstarstarstarstar Excellent

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

Excel intermadiate

resolvedResolved · Medium Priority · Version 2003

Mon 17 Aug 2009, 16:52 replyReply Delegate Aimee said...

Excel intermadiate

How do I protect cells on a sheet?

Many Thanks
Aimee

For upcoming training course dates see: Pricing & availability

Tue 18 Aug 2009, 14:24 replyReply Trainer Amanda said...

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:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips