insert pic

Copper Contributor

Hi I am very new to this excel stuff. Is there any way I can insert my picture from photos and have it start a predetermined size? They take up the whole page then i have to grab them and push them down to size.

1 Reply

@Davebcor 

Yes, there is a way to insert an image from your photo folder into Excel and have it start at a predetermined size.

You can do this by going to Insert > Pictures > Selecting your picture > Insert.

Then, when you have the image selected, you’ll see a “Size” grouping under “Format” and “Picture Tools”

Change the Height and Width to adjust the size of your image.

 

There is also a new function called IMAGE, which returns an image within a cell.

This function allows you to insert images into cells from a source location, along with alternative text.

You can use this function by typing 

=IMAGE(source, [alt_text], [sizing], [height], [width]) into a cell.