Hi all
I am new to this forum and have a little knowledge of excel
What I want to achieve if possible is to insert a picture in to an excel spread sheet, so that the picture automatically resizes the height but not the width of the cell and therefore push the remaining rows in the sheet down the page accordingly.
The pictures are all the same size 6 cm high by 8 cm wide. I don't want the cell width to be adjusted, as the width of the cells above and below have been set to suit the information in them. but the cells where the picture is inserted can be merged across or merged and centred if that makes the process easier.
The spread sheet is divided into different sections some sections will have photos and some will not, this will vary between uses, the pictures will be inserted at the bottom of each section. I want to leave a blank cell beneath each row of pictures for text. Obviously at the the size of the pictures I can only get 2 pictures per row, and be able to print on A4 paper, some sections will require more than two pictures so I need to be able to insert them with the text row in multiple rows as needed. Some sections will have no pictures and I don't want large blank cells in the spread sheet where there were no pictures inserted.
I can do this manually but it is time consuming and I was hoping to automate the process.
can any one help?
Thanks in advance for any help given
I am new to this forum and have a little knowledge of excel
What I want to achieve if possible is to insert a picture in to an excel spread sheet, so that the picture automatically resizes the height but not the width of the cell and therefore push the remaining rows in the sheet down the page accordingly.
The pictures are all the same size 6 cm high by 8 cm wide. I don't want the cell width to be adjusted, as the width of the cells above and below have been set to suit the information in them. but the cells where the picture is inserted can be merged across or merged and centred if that makes the process easier.
The spread sheet is divided into different sections some sections will have photos and some will not, this will vary between uses, the pictures will be inserted at the bottom of each section. I want to leave a blank cell beneath each row of pictures for text. Obviously at the the size of the pictures I can only get 2 pictures per row, and be able to print on A4 paper, some sections will require more than two pictures so I need to be able to insert them with the text row in multiple rows as needed. Some sections will have no pictures and I don't want large blank cells in the spread sheet where there were no pictures inserted.
I can do this manually but it is time consuming and I was hoping to automate the process.
can any one help?
Thanks in advance for any help given