timothy.sides
New Member
- Joined
- Mar 11, 2010
- Messages
- 2
I have a spreadsheet where most all the cells are data validated with a drop down list. I only want users to be able to enter name, select drop down variable and finally be able to cut & paste data to other cells. My problem arises when the users cut & paste, the cell borders don't stay constant. So I'm wondering if we can lock cell formatting only but still allow users to enter data and cut and paste when applicable. Using Excel 2007. Any suggestions would be appreciated.