News

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.


Don’t take our word for it, see what are our clients say

The service that we receive is of the highest standard and we are completely happy that we have made the right decision to move our business to SMT IT Services.

- Chris Addis -