View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DS-NTE DS-NTE is offline
external usenet poster
 
Posts: 24
Default how i can protect few rows or few coloumn?

By default all cells are locked whwn you protect a sheet, you have to do it
this way:
Select all the cells you dont want to protect then choose Format/Protection,
uncheck "Locked", then protect your sheet.


hth

"vlook fomula" skrev i melding
...
Dear Sir,
i applied your given instructions (choose Format/Protection. Your options
are there.)
i could not get any sucess and there. secondly i can protect hole
worksheet
now but i cant get sucess to protect specific area of a sheet. kidly do
the
need full?
"RFJ" wrote:

Highlight the cells you want to protect, right click the mouse button and
choose Format/Protection. Your options are there.

From the main menu*, you then have the option of protecting the whole
workbook or worksheet. That enables the protection you put on in the
format
command

In OL2007 it is Review/ and your options are on the ribbon bar.

"vlook fomula" wrote in message
...
my question is " how i can protect a spacific area of a worksheet?
either
few
cells, rows or few coloumns?