How we can help

Need help with your Managed IT Services?

Our team are available Mon – Fri: 7:30am-5:30pm

Call Now On:
Stourport: 01299 848311 Hereford: 01432 663026

Technical Support

Contact us

- 16th Nov 2022

Tech Tip - Convert Picture Of A Data Table To A Usable One In Excel

Microsoft Excel is still one of the world’s most widely used data tools and a new feature (for desktop), ‘Data from Picture’, means that you can now import a picture of a data table and convert it into a usable one within Excel. Here’s how: 

– Save a cropped-down screenshot of an excel data table. 

– Open Excel and go to the ‘Data’ tab (top menu). 

– Select the (new) ‘From Picture’ option (top menu). 

– From the drop-down options choose ‘Picture from file’. 

– Select and click ‘insert’. Right hand side of the screen will show as collecting and preparing data. 

– Click ‘Review’ or ‘Insert Anyway’ if happy you’re happy that the table produced is accurate. 

Google Rating
Based on 42 reviews