ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to lock a cell (https://www.excelbanter.com/excel-worksheet-functions/121016-re-how-lock-cell.html)

Alok

How to lock a cell
 
Click on the cell and then click on Data/Validation..

Locking is a different concept which in Excel terminology means preventing
the user from entering any data or formula in the cell.

"Skjetve" wrote:

How do you lock a cell, so the user can only write positive numbers in it?



All times are GMT +1. The time now is 04:39 AM.

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