Tag Archives: Copy Paste

How to paste as text in OneNote

Paste as text is a simple yet useful thing. If you copy paste from anywhere into OneNote it takes a little longer than usual, especially if it is from a browser page. It also shows progress bars like Contacting the server. In addition, OneNote automatically pastes the URL of the web page at the bottom of the content pasted.

In most cases this is a good thing. But in some cases, you KNOW that you just want to paste as text. In such cases, you have to click Home tab – Paste Special and choose Keep Text Only. If you need this option often, you cannot add it to QAT. Adding the entire dropdown to the QAT defeats the purpose. It still remains a two click operation. But of course, there is a solution.

Continue reading How to paste as text in OneNote

What did I learn today? WLW Paste Special

Small but useful thing. In Windows Live Writer, I discovered Paste Special Options. Three options: Try copying from Word.

Windows Live Writer Paste Special - Dr. Nitin Paranjape

Depending upon the contents of the clipboard, the options change. Notice them and use them. I also noticed a bug. If Undo is pressed after a Paste operation, WLW does NOT Undo the paste operation. Undo only affects the actions done BEFORE the paste operation. Be careful. You may miss the unintended UNDO impact.

DO NOT copy paste data from browser. Use Power Query.

This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up the unwanted things which also got pasted.
If you have Excel 2010 or above (Professional Plus or Office 365 edition),
you have a miraculously simple method available now : Power Query

stop copy pasting from browser - by Dr. Nitin Paranjape

Continue reading DO NOT copy paste data from browser. Use Power Query.