How to Rotate a Worksheet in MS Excel 2003

1. Select the entire table you want to rotate by left clicking at the top, left cell, dragging the mouse down to the bottom, right corner, and releasing.
2. Press 'Ctrl' and 'C' at the same time to copy your table.
3. Select a cell somewhere outside of the table you're rotating. You can even select a cell on a different worksheet entirely.
4. Click the black, down arrow under 'Paste' in the Clipboard section of the Home tab. Select 'Paste Special.'
5. Click the 'Transpose' check box, then click 'OK' to paste the transposed data.