Smart Paste from Notepad to Excel智能从记事本粘贴到Excel
By default when you paste something in excel it gets copied in just one cell which might not be just your requirement.默认情况下,当您贴的东西在Excel中复制它得到只在一个细胞有可能不只是你的要求。 Generally if you paste something in excel it will appear in the cell you selected it.一般来说如果你的东西贴在Excel中它将会出现在您所选取细胞它。 This becomes difficult.这已成为困难。 Now lets sa y you want to paste in such a way that some of the text appear in first column and some in second and so on , how do you do that ?现在,让山y要粘贴在这样一种方式,有些文字出现在第一栏和一些在第二,等等 ,你如何做到这一点?

Its the same way we did for它以同样的方式我们为 power point presentation功率点介绍 . 。 I call it power of tabs used in notepad and used in Microsoft Office applications.我呼吁它的权力标签使用记事本和使用微软Office应用程序。 Just arrange the same way we did for Power point and either you can copy paste it in excel or just open it with excel.只要安排同样的方式我们没有权力点,或者您可以复制它贴在Excel或刚刚打开它与Excel 。 Check the image above , because of the new line they appear in different cells and tabs make them shift to next columns.检查上图中,由于新的生产线出现在不同的细胞和标签使他们转移到下一个栏。
Tags:标签: excel tips善于秘诀 , , microsoft office applications Microsoft Office应用程序 , , notepad features记事本功能 , , power point presentation功率点介绍

Ashish Mohta Ashish Mohta is A tech blogger who writes about solving day to day problems of people who use computer.是A科技博客谁写了关于解决日常问题的人谁使用计算机。 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


[...] Mohta posted an interesting Microsoft Excel tip at his website that explained how to smart paste contents from Notepad into Microsoft Excel. [...] Mohta张贴一个有趣的Microsoft Excel尖在他的网站,解释了如何智能粘贴的内容从记事到Microsoft Excel 。 The procedure is actually working with any kind of text [...]该程序实际上是同任何形式的文字[...]
Leave your response!离开你的答复!