I have excel pages every page has photo and descriptopn beside it, I want to put all pages in one page the problem when I copy one column (photo and desription list) on a new page it doesnt paste the same width and heights of the same copied list so list appears photos scattered and descritpion normal so I need to paste multple columna in one column so no need to rescale every one photo and descritipn height and wodth
A Toykan
@Reply 8 days ago
Use paste special to paste the formats, width, etc.
A Toykan is on the right track. When you copy the cells, use Paste Special and choose to paste the column widths as well as the regular contents/formats. Excel does not always bring the original column widths along with a normal paste.
Also, make sure the pictures are set to move and size with cells. Right-click a picture, choose Format Picture, go to Size & Properties, and select "Move and size with cells." Then, when you copy the rows and columns, the pictures should stay lined up with their descriptions instead of scattering around the sheet.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
