Transpose Excel cells ( Row to Column and reverse ) quickly
This is a nice office trick if you want to transpose or change set of cells in excel files from row to column or column to row quickly. Here are the steps
- Select the cells and copy it.
- Now select anywhere you want to transpose and hit ALT + E > S and then select Transpose.
Related : Moving Quickly between parts of Excel sheets with Named Ranges
Tagged with: cell transpose • excel 2007 tips • excel tips
| Need more help ? Ask your Questions at our Support Center | Follow us on Twitter @TSNW or Facebook
Posted on 16th August 2008 by Ashish Mohta , A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. He also writes on How to use the applications like Office, PC tips, Online tools,Browsers and more. All posts by Ashish Mohta | Connect with me @ Twitter | Linkedin | Facebook | Stumble
Sign up for our daily email newsletter
Leave your response!