How do I prevent a user from entering data in a cell?
I am trying to lock down a contiguous group of cells so that the user cannot
change the data or formula. How do I do that? |
How do I prevent a user from entering data in a cell?
--Select the whole sheet, right clickFormat cellsProtection (last tab), and
uncheck locked. --Now select your range of cells to be locked Right clickFormat cells Protectioncheck the locked box --Now protect your worksheet. Users will be able to edit and change information everywhere other than the last selected range If this post helps click Yes --------------- Jacob Skaria "jaydub100" wrote: I am trying to lock down a contiguous group of cells so that the user cannot change the data or formula. How do I do that? |
All times are GMT +1. The time now is 06:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com