Greetings,
I have an excel raw data capture spreadsheet containing 8 of the following formats in which readers must input values for columns 6 to 1:
6 5 4 3 2 1
A
B
C
D
E
F
G
H
10 11 12 13 14 15
the column headers and footers should not be changed by the user. Currently, we have a system were all cells are unprotected and cells from A6 through H1 (48 cells) have a validation that accepts a defined range of values from a drop-down list. We have been having issues lately with "no entries - i.e. blank cells" and users actually typing over the column headers, footers and the row identifiers. This creates problems later on in our data analysis. In addition, we have tried to protect the cells that we do not want altered previously. However, as we use the same data form and input new values for the column footers each time, we had to protect and unprotect the cells for each new data collection event. We have tried to validate in layers and have found out that this is also not possible. How can we protect our sheet identifiers while allowing users to enter values within a defined range and not accept blank cell entries? Any help is much appreciated.
Regards,
Alissa
I have an excel raw data capture spreadsheet containing 8 of the following formats in which readers must input values for columns 6 to 1:
6 5 4 3 2 1
A
B
C
D
E
F
G
H
10 11 12 13 14 15
the column headers and footers should not be changed by the user. Currently, we have a system were all cells are unprotected and cells from A6 through H1 (48 cells) have a validation that accepts a defined range of values from a drop-down list. We have been having issues lately with "no entries - i.e. blank cells" and users actually typing over the column headers, footers and the row identifiers. This creates problems later on in our data analysis. In addition, we have tried to protect the cells that we do not want altered previously. However, as we use the same data form and input new values for the column footers each time, we had to protect and unprotect the cells for each new data collection event. We have tried to validate in layers and have found out that this is also not possible. How can we protect our sheet identifiers while allowing users to enter values within a defined range and not accept blank cell entries? Any help is much appreciated.
Regards,
Alissa