At 14:31 23/12/2010 +1000, Eihua Ling wrote:
How do i change from x-axis to y-axis in the excel file??1 2 3 4 5 6 7 8 9 10 ---> 1 2 3 4 5 6 7 8 9 10
(You have come to the wrong place if you really mean that you are working in Microsoft Excel; I assume you mean that you are working in OpenOffice Calc, in fact.)
As so often, Paste Special is your friend: o Select the relevant cells. o Go to Edit | Cut (or Ctrl+X). o Click the top left cell of the destination range. o Go to Edit | Paste... (or Ctrl+Shift+V). o In the Paste Special dialogue, under Options tick Transpose. o Click OK. I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
