The problem I am going to show you how to solve is to take data from a screen that doesn’t have a “PRINT” or “EXPORT” function. You get data in to Excel from a screen dump via OneNote.
There could be several reasons why you can’t print so it might be worthwhile to get your IT department to look at the software – is there a training issue or should it be put to the supplier as a development of the product?
This is a generic workaround. Any Windows based computer that has Microsoft Office on will have OneNote. It is free to use.
I will use information taken from a website to demonstrate. This data is taken from a publically available source located at https://www.england.nhs.uk/statistics/wp-content/uploads/sites/2/2018/02/MAR-December-17-SPN-7832.pdf
The process should work from any website, web based document or piece of Windows software UNLESS print screen is disabled.
Step 1 Click on Print Screen – this copies a picture of the screen in to the clipboard
Step 2 Paste this image in to OneNote
Step 3 Right Click on the picture and Copy Text from Picture. OneNote will use OCR to convert this in to text (see picture below)
Step 4 Paste this text in to Excel which will be ready for editing.
Please view the accompanying video at https://youtu.be/lgugXY2MXuA