Cell selection without Editing

Guys,

Please I need your help, I want to know ho to enable selecting the cells (copy, and select ) but with disabling editing the text inside this cell.\


Thanks in advance

Hello Mido,

I think you are talking about Protection.

When you format a cell, there is a tab for Protection. By default, all cells are Locked. This means that when a worksheet is Protected, the cell can be selected, but the not changed by the user. (This is good for formulas you don't want changed etc.)

In Excel 2003, select Tools/Protection/Protect Sheet to turn the protection on. You don't have to use a password if you don't want to. If you do, make sure you remember it, because it can be permanent.

Hope this helps.

David



Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".