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.

Related posts:

  1. How to copy only comments from a cell in Excel 2010 / 2007
  2. Notepad 2008 : An advanced notepad with Microsoft office Looks
  3. Features of Microsoft’s XML Notepad and How to
  4. How to quickly add, multiply, subtract and divide 2 Excel columns
  5. Let that middle button of your mouse do a paste in Firefox
Tagged with: | Need more help? Make a search below.
Author Details

Posted on 12th October 2008 by , A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. His expertise are in Windows 7, Microsoft Office, Software, Mobile Apps and Video Posts. All posts by | Connect with me @Twitter | Linkedin | Facebook | Stumble



Readers Comment