title: Excel sortable read-only/locked columns
body: <p>How to enable sorting on locked cells (columns) in Excel 2010?</p>
  
  <p>Tried many methods, including what seemed to be the correct method (i.e. protecting sheet and leaving <code>Sort</code> option checked) but still unable to sort.</p>
  
  <p>Example:</p>
  
  <pre>
    Question                   Answer
    ========                   ======
    What's your name?          Johnny
    How old are you?           703
  </pre>
  
  <p>I want Question column locked (so user can't change the question) and Answer column not locked (so user can enter answer!). But I want to be able to sort on the Question column.</p>