View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Freezing Formulas Question 2

In the English version:
Format|Cells|Protection tab (not Security)

MartinW wrote:

Hi Barbara,

Just to explain further. Select the first cell you wish to allow
'user input' in. Then hold down control and click on all the
other 'user input' cells. Once they are all selected let go of
the control button and go to FormatCellsSecurity tab
and 'uncheck' the locked option and OK out.

Now when you apply protection you will be able to change
only those cells that have been unlocked.

HTH
Martin


--

Dave Peterson