Home » Office Tips

Smart Paste from Notepad to Excel

By default when you paste something in excel it gets copied in just one cell which might not be just your requirement. Generally if you paste something in excel it will appear in the cell you selected it. This becomes difficult. Now lets say 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 ?

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. 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. 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
SMS subscribe Print This Post

Posted on 12th October 2008 by 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 | Connect with me @ Twitter | Linkedin | Facebook | Stumble | Need more help? Ask your Questions at our Support Center



One Comment »

  • Learn Microsoft Excel: Smart Paste said:

    [...] Mohta posted an interesting Microsoft Excel tip at his website that explained how to smart paste contents from Notepad into 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>