Home » » Office Tips 办公室秘诀

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要粘贴在这样一种方式,有些文字出现在第一栏和一些在第二,等等 ,你如何做到这一点?

Smart Paste from Notepad to Excel

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:标签: , , ,

Translate to EnglishÜbersetzen Sie zum Deutsch/GermanПереведите к русскому/RussianΜεταφράστε στα ελληνικά/GreekVertaal aan het Nederlands/Dutchترجمة الى العربية/Arabic中文翻译/Chinese Traditional中文翻译/Chinese Simplified한국어에게 번역하십시오/Korean日本語に翻訳しなさい /JapaneseTraduza ao Português/PortugueseTraduca ad Italiano/ItalianTraduisez au Français/FrenchTraduzca al Español/Spanish
短信订阅Print This Post

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 支援中心




One Comment一个评论 »

  • Learn Microsoft Excel: Smart Paste 了解Microsoft Excel中:智能粘贴 said: 说:

    [...] 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!离开你的答复!

Be nice.很好。 Keep it clean.保持清洁。 Stay on topic.留在话题。 No spam.没有垃圾邮件。

You can use these tags:您可以使用这些标签:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>