Instead of copying and pasting, you can quickly copy data from a web browser to Excel, by dragging and dropping.
Video: Copy Web Data to Excel
To see the steps in action, you can watch this 30 second video. The full transcript is below the video.
Video Transcript
If you want to copy something from a web browser, into Excel, you can just drag and drop
On my website, I’m just going to scroll down a little, and select some text, and links, and graphics
Then, just point anywhere, even if it’s the clicking hand
Instead of clicking, we’re going to just drag over here to Excel
Let go, and it copies the links, the text, the graphics, and you’re ready to go!
___________
use Firefox. I can highlight text and drag it from browser on to excel single cell. I cant do it using chrome or explorer. saves me 75% of my time