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功率點介紹
 |  |  |  |  |  |  |  |  |  |  |  |  |  |
Posted on 12th October 2008 by發布於08年10月12號的 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
[...] 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!離開你的答复！