I am trying to protect specific rows and columns on a worksheet. I select
all, go to protection and uncheck the locked cells box. Then highlight the
rows and columns I want protected, go back in to lock the cells via right
clickformat cells and it tells me "Cannot change part of a merged cell."
what am I doing wrong here?