| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To allow edit of particular rows and protect other rows from editi
I would like to protect a Excel WorkSheet and at the same time allow only
particular rows or columns for editing or data entry. How this can be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To allow edit of particular rows and protect other rows from editi
Before turning on Sheet protection with Tools Protection Protect Worksheet Select the cells that you want to allow input to, and select Format Cells Protection and uncheck "Locked." No when you do Tools Protection Protect Sheet, the selected cells will remain open for user input. DHANRAJ Wrote: I would like to protect a Excel WorkSheet and at the same time allow only particular rows or columns for editing or data entry. How this can be done? -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=527929 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To allow edit of particular rows and protect other rows from e
Thanks Captain,
It was a useful tip. dhanraj.r "CaptainQuattro" wrote: Before turning on Sheet protection with Tools Protection Protect Worksheet Select the cells that you want to allow input to, and select Format Cells Protection and uncheck "Locked." No when you do Tools Protection Protect Sheet, the selected cells will remain open for user input. DHANRAJ Wrote: I would like to protect a Excel WorkSheet and at the same time allow only particular rows or columns for editing or data entry. How this can be done? -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=527929 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to protect some cells, but able to insert rows elsewhere? | Excel Discussion (Misc queries) | |||
| To Protect Excel documents and allowing only few cells to edit | Excel Worksheet Functions | |||
| Protect formulas but allow deletion of rows? | Excel Discussion (Misc queries) | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
| Protect worsheet, but allow user to hide rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
