How to sort and filter embed objects in Excel

In this tutorial you learn how to sort and filter embed objects in Excel.

Hope you know how to insert object in excel file. Click on below link to know how to insert objects in excel file.

https://goo.gl/AuzNMQ

To Sort or Filter embedded object in Excel first you have to change format of Object.

Select one object and then press Ctrl + A to select all objects. If this is not worked then press F5 key or Ctrl + G and go to Special and select last Objects option to select all objects from sheet.

Then right click and select Format Object Option.

In Format Object window go to properties tab and select option Move and size with cells and hit Ok button.

Now you can see objects also filtered with numbers.

And to sort data select all Data including attachment column (Column B) and sort data as you want. Objects will be sorted with numbers.

 

Note - Make sure files are embed properly into the cells otherwise sorting won't work.

Hope you understand. Thank you.

Watch Video - 

 

Have a nice day... Enjoy Exceling....