Sorting excel document containing embedded pdfs

S

sallymh

I have a spreadsheet which contains an embedded pdf on each row. When I sort
the sheet one or more pdfs don't move resulting in some rows having multiple
pdfs contained in that cell and some rows having no pdfs in that cell.
 
B

BizMark

sallymh said:
I have a spreadsheet which contains an embedded pdf on each row. When
sort
the sheet one or more pdfs don't move resulting in some rows havin
multiple
pdfs contained in that cell and some rows having no pdfs in that cell.
Click to expand...

What you'll need to do for each icon is to right-click on it, selec
'Format Picture' or 'Format Object', then go to the 'Properties' pane
and ensure that the option 'Move and Size with cells' is checked.

Alternatively, if you have a very large number of icons, activate th
drawing toolbar ('View'>'Toolbars'>'Drawing'), select the 'pointer
(arrow) tool, then draw a marquee around the column of icons, the
right-click on any one of the icons and perform the step above.

Regards,
M
 
Top