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
Yes. I know this is a commonly used feature. In spite of that, I am saying that you should never use Paste Special Values in Excel. Read on to find out why.
Continue reading Never use Paste Special Values in Excel
Small but useful thing. In Windows Live Writer, I discovered Paste Special Options. Three options: Try copying from Word.
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.
This article explains some confusing options in a “Special” Paste Special dialog.
Estimated reading time 3min.
Continue reading Copy Paste – Part 15 – “Special” Paste Special
OneNote linked notes are easy to create.
But how do you manage these linked notes later?
Here is an easy way to do it.
Estimated reading time 3 min
Continue reading What did I learn today: How to manage Linked Notes
I started this blog with articles about Copy Paste. Now this is article no 307.This knowledge pack contains 19 articles. I strongly recommend that everyone should go through these articles. It is a life changing experience!
Estimated reading time 40 min
Continue reading Weekend Reading: Copy Paste Knowledge Pack
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…
Continue reading DO NOT copy paste data from browser. Use Power Query.