#1
|
|||
|
|||
Help with pasting screen shots in Excel
I intend to collect hundreds of screen shots and place them in Excel because it is very easy to scroll through them later on. I will gather around 50 per day. However after placing few tens of them, the file size gets huge and Excel displays a "Not responding" message when saving the file. After a while the message disappears and the file is saved. However I fear that I will soon reach a point when it will eventually crash.
My question is what if anything can be done to reduce the size of the images? I tried placing them first in Paint and reducing them from 100 to 50% and then adding them to Excel, but the Excel file size is only slightly smaller. So this way doesn't work. The screen shots I collect contain numbers, so not a great deal of resolution is needed. To give you an idea a screen shot contains around 50 rows and 15 columns with numbers up to 7 digits. I use Office 2010 and my Excel file currently reached 701Mb. I tried saving the file as a 2003 Excel file and the size went down to 35Mb, but when I work with this file it also displays the Not responding message when saving, but it only lasts few seconds and then it's saved. It will soon reach a point when it won't work anymore. In case this can help, I use the Snipping tool to collect the screen shots I need. Thank you, Dual Trace |
#2
|
|||
|
|||
Generally GIF format is smaller than JPG or other formats.
However, you are storing the images in the workbook itself. Why not change your project to save the images to a folder first. Then create a macro that will display the images one at a time. This will prevent Excel from 'freezing'. |
#3
|
|||
|
|||
I use the snipping tool to grab the screen shots and then CTRL+C and CTRL+V to place them in Excel. This works pretty quickly. I do around 50 per day in maybe 20 min. If I need to first save each as a gif, this would imply many time consuming steps.
|
#4
|
|||
|
|||
If you want to save a selection to a folder you should be able to use one of these suggestions.
John Peltier at https://www.mrexcel.com/forum/excel-...lls-jpg-2.html Post #16 RoryA https://www.mrexcel.com/forum/excel-...g-chart-2.html Post #11 Stephen Bullen is mentioned also. I have used his code but that was quite a few years ago. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pasting from excel | bflan0524 | PowerPoint | 0 | 07-13-2017 08:19 PM |
Excel 2013 pasting value not formula | bumbrlik | Excel | 1 | 12-20-2016 07:05 PM |
Document 66MG after inserting screen shots | sleake | Word | 0 | 06-07-2012 08:14 AM |
Copying and pasting from Excel | Lorna B | Word | 1 | 03-20-2012 11:58 PM |
Blurry Screen Shots | ashb | Word | 0 | 06-28-2006 01:37 PM |