How to show files with lighbox/colorbox effect?
My first problem is to get lightbox or Colorbox to display the file on click on the page
  


For this you need to set either lightbox or colorbox module. Once you install and enable the site you will see the option in file field to show the file in lightbox.


  
    he second one is to remove certain content type files from the views display
  


Add a filter criteria File Usage: Entity type or File Usage: Entity Id and exclude user entity.


  
    Thirdly, i want to create a menu to sort the file per type
  


For this you need to add a sort criteria based on your File:Mime Type