title: Transpose in excel doesn't work, it just copies one cell
body: <p>I've been researching for quite a while and I cannot find the solution to this problem. I need to switch the values of some rows and columns in excel and I saw that I could use transpose, put the array I need to swap and press CTRL+SHIFT+ENTER.</p>
  
  <p>I am doing that but the result is that it just copies a single cell, the 1st one, nothing happens to the other ones selected in the array. </p>
  
  <p>I am using Office 2010 and this is the result. Any idea what could be happening and how I could fix it? 
  Thank you!</p>
  
  <p><img src="https://i.stack.imgur.com/PGw2N.png" alt="enter image description here"></p>