amaresh achar
Board Regular
- Joined
- Dec 9, 2016
- Messages
- 108
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to lock access for different set of cell ranges with different passwords.
Set of ranges (total 507 ranges) with range title "Supplier" are as mentioned below:
K23:T23
K25:T25
K27:T27
K29:T29
.
.
.
.
K1033:T1033
K1035:T1035
Set of ranges (total 507 ranges) with range title "IQC" are as mentioned below:
K24:T24
K26:T26
K28:T28
K30:T30
.
.
.
.
K1034:T1034
K1036:T1036
I am trying this to do using "Allow Edit Ranges" option in Excel.
Since these are intermittent / alternate rows, I am manually selecting the ranges in "Refers to cells" field and at some point, it stops accepting the selection.
Can anyone help me to overcome this issue...??? Or suggest a compact way of defining this type of intermittent ranges of cells for "Allow Edit Ranges" option in Excel...???
Thanks in Advance...
I am trying to lock access for different set of cell ranges with different passwords.
Set of ranges (total 507 ranges) with range title "Supplier" are as mentioned below:
K23:T23
K25:T25
K27:T27
K29:T29
.
.
.
.
K1033:T1033
K1035:T1035
Set of ranges (total 507 ranges) with range title "IQC" are as mentioned below:
K24:T24
K26:T26
K28:T28
K30:T30
.
.
.
.
K1034:T1034
K1036:T1036
I am trying this to do using "Allow Edit Ranges" option in Excel.
Since these are intermittent / alternate rows, I am manually selecting the ranges in "Refers to cells" field and at some point, it stops accepting the selection.
Can anyone help me to overcome this issue...??? Or suggest a compact way of defining this type of intermittent ranges of cells for "Allow Edit Ranges" option in Excel...???
Thanks in Advance...