Forum Discussion

nigelhig's avatar
nigelhig
Copper Contributor
Feb 06, 2021

resize pictures

I am using an app to scan barcodes and take picture of books which import directly into excel spreadsheet. It works fine but I need to keep the images to a thumbnail size as there ae hundreds of pro...
Excel for web
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Feb 06, 2021

nigelhig 

Embed images in Excel

First insert the desired image from the clipboard into your Excel table using copy (shortcut: Ctrl + C) and paste (shortcut: Ctrl + V).

Now reduce the image so that it fits into the cell. To do this, you simply have to drag the corners of the image to the correct size with the mouse. Alternatively, you can of course also adjust the column and row size.

With the Alt key you can now position the image in the correct cell.

Then right-click on the picture to open the context menu and select "Size and Properties".

Under "Properties" you will find the point "Depending on cell position and size". This means that the image is adapted to the formatting and is taken into account, for example, when sorting the lines.

 

Don't forget to use Excel for the web.

Work with VBA macros in Excel for the web

https://support.microsoft.com/en-us/office/work-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343?ui=en-US&rs=en-US&ad=US

 

I hope I could help you.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.