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

Excel intermadiate

ResolvedVersion 2003

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

Aimee has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Word Intermediate course

Excel intermadiate

How do I protect cells on a sheet?

Many Thanks
Aimee

Tue 18 Aug 2009, 14:24 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Excel intermadiate

Excel intermadiate

RE: excel intermadiate

Excel articles

Excel tip:

Move data worksheet to worksheet