Forum Discussion

cf365-0330_May's avatar
cf365-0330_May
Copper Contributor
May 03, 2019

Help Needed Rotate Excel Sheet from Landscape to Portrait

I need help! I created a worksheet but need to switch the top row (the ages) to the side column row where the 5 main categories are. Is this possible without having to move and redo the entire sheet? There is information already in the sheet. 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    cf365-0330_May , insert empty column, select the range from your top row you'd like to transform, Copy, stay on first cell of the new column, Paste->Paste special->Transform

Resources