Is it possible to block (or lock) a range of cells from accepting data from a specific user after this user has entered numerical data in to one cell from that particular range? We are using M365 version of Excel. If yes, what would be the easiest way to accomplish this? Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Lock Cells Based on a Condition
- Thread starter BNad
- Start date
Excel Facts
Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Similar threads
- Question
- Replies
- 0
- Views
- 98
- Replies
- 5
- Views
- 352
- Replies
- 0
- Views
- 213
- Replies
- 4
- Views
- 312
- Replies
- 5
- Views
- 221
