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!
___________
Nope, it’s always TNR, main text at least 12 pt (10 is fine for regular text) and the largest header is like 36 pt. I should probably apply a template with fixed up styles, but I don’t need this too frequently, once or twice a month.
@Deb – You are right, the title looks fine to me too… now 😉
MS Office drag-and-drop is frequently flakey because Office maintains its own clipboard outside the one that is part of Windows itself. I’ve seen situations where copying directly from MSIE or Firefox into either Excel or Outlook does not work but copying into Word and then copying from Word into Excel or Outlook does the trick. Why three MS programs are sometimes needed when two don’t work right I have no idea, I guess it’s like the Holy Hand Grenade from Monty Python:
And the Lord spake, saying, “First shalt thou take out the Holy Pin, then shalt thou count to three, no more, no less. Three shall be the number thou shalt count, and the number of the counting shall be three. Four shalt thou not count, neither count thou two, excepting that thou then proceed to three. Five is right out.
http://en.wikipedia.org/wiki/Holy_Hand_Grenade_of_Antioch
[…] Such is dragging data from a browser into Excel. […]
[…] month, I showed you how to drag information from a web browser into Excel. You can also drag text files, to open them quickly in Excel. I find this a really quick way to […]
Wow this is a great tip! Just told the other people in our office and all were impressed (it’s something that’s annoyed many of us for many years). Thanks for the tip!