ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I protect cells in Excel 2000? (https://www.excelbanter.com/excel-worksheet-functions/23141-how-can-i-protect-cells-excel-2000-a.html)

Rajat

How can I protect cells in Excel 2000?
 
I need to protect only few cells in xl sheet and not the whole worksheet or
workbook as i m working with formulae. How this can be achieved? I m using
Office 2000

Peo Sjoblom

Select the whole sheet, do formatcellsprotection, uncheck locked
select the cells that you want to protect, repeat and select locked, protect
the sheet

--
Regards,

Peo Sjoblom


"Rajat" wrote in message
...
I need to protect only few cells in xl sheet and not the whole worksheet or
workbook as i m working with formulae. How this can be achieved? I m using
Office 2000





All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com