If you come across data you want to add to an Excel spreadsheet, but copying and pasting it doesn’t work (or seems like too much work), you can also take a screenshot of the table. Then, you can use a little-known Excel import feature to migrate the data from your screenshot to your spreadsheet.
To ensure that the screenshot contains only the data table and not the entire screen, press the Win-Shift-S key combination to bring up the Windows Snipping Tool. Then use the mouse to draw a rectangle around the table area only. This saves the screenshot in your Windows clipboard.
Open Excel, select the “Data” tab, and navigate to From Picture > Picture From Clipboard. Excel then imports the screenshot’s information and displays the data on the right-hand side of your spreadsheet for checking and pasting.
If you want to import information from a saved screenshot, use From Picture > Picture From File instead.
[ Save $20 on Microsoft Office Home & Student in PCWorld’s Software Store ]
This article was translated from German to English and originally appeared on pcwelt.de.
https://www.pcworld.com/article/2059081/to-import-excel-tables-from-screenshots.html
Login to add comment
Other posts in this group
Microsoft has added GPT-5 to Copilot, a day after adding OpenAI’s ope
OpenAI on Thursday announced GPT-5, the foundational model for the ne
Microsoft has made a big deal of the fact that Windows 10 moves out o
Prompt injection is a method of attacking text-based “AI” systems wit
How much speed do you need when you’re getting sweaty with your gamin
