Transpose Excel cells ( Row to Column and reverse ) quickly移调Excel单元格(行栏和扭转)迅速
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这是一个很好办公室把戏如果你想调换或改变的细胞从Excel文件连续列或栏,行迅速。下面的步骤操作,
- Select the cells and copy it.选取细胞和复制。
- Now select anywhere you want to transpose and hit ALT + E > S and then select Transpose.现在选择任何你想转击中按ALT + é “ S和然后选择移调。

Related :相关: Moving Quickly between parts of Excel sheets with Named Ranges快速移动各部分之间的Excel工作表的命名范围
Tags:标签: cell transpose细胞移 , , excel 2007 tips Excel 2007中的提示 , , excel tips善于秘诀


Posted on 16th August 2008 by发布于2008年8月16号的 Ashish Mohta Ashish Mohta , A tech blogger who writes 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 Ashish Mohta | Connect with me @ |与我联系@ Twitter 叽叽喳喳 | | Linkedin LinkedIn的 | | Facebook 脸谱 | | Stumble 失败 | Need more help? |需要更多的帮助? Ask your Questions at our 问问你的问题在我们的 Support Center 支援中心






























Free Email Subscription


Leave your response!离开你的答复!