Home

Help Needed Rotate Excel Sheet from Landscape to Portrait

%3CLINGO-SUB%20id%3D%22lingo-sub-525361%22%20slang%3D%22en-US%22%3EHelp%20Needed%20Rotate%20Excel%20Sheet%20from%20Landscape%20to%20Portrait%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525361%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help!%20I%20created%20a%20worksheet%20but%20need%20to%20switch%20the%20top%20row%20(the%20ages)%20to%20the%20side%20column%20row%20where%20the%205%20main%20categories%20are.%20Is%20this%20possible%20without%20having%20to%20move%20and%20redo%20the%20entire%20sheet%3F%20There%20is%20information%20already%20in%20the%20sheet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-525361%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-525370%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%20Rotate%20Excel%20Sheet%20from%20Landscape%20to%20Portrait%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332922%22%20target%3D%22_blank%22%3E%40cf365-0330_May%3C%2FA%3E%26nbsp%3B%2C%20insert%20empty%20column%2C%20select%20the%20range%20from%20your%20top%20row%20you'd%20like%20to%20transform%2C%20Copy%2C%20stay%20on%20first%20cell%20of%20the%20new%20column%2C%20Paste-%26gt%3BPaste%20special-%26gt%3BTransform%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
cf365-0330_May
Occasional Visitor

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

@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

Related Conversations