You can’t make document alterations more convenient than editing your excel files on the web. With DocHub, you can access tools to edit documents in fillable PDF, excel, or other formats: highlight, blackout, or erase document fragments. Include textual content and pictures where you need them, rewrite your form completely, and more. You can download your edited record to your device or submit it by email or direct link. You can also turn your documents into fillable forms and ask others to complete them. DocHub even provides an eSignature that allows you to certify and deliver paperwork for signing with just a couple of clicks.
Your documents are safely stored in our DocHub cloud, so you can access them anytime from your desktop, laptop, mobile, or tablet. If you prefer to apply your mobile device for file editing, you can easily do it with DocHub’s mobile app for iOS or Android.
in this video Iamp;#39;m going to show you a couple of ways you can look up pictures based on a value in a Cell linked either to a data validation list or a selection made in a slicer and thereamp;#39;s no VBA or macros involved just a couple of basic formulas now Iamp;#39;m using some images of the tour to France race stages but you could use this technique with product images employees logos anything really letamp;#39;s take a look the first step is to bring your image into the Excel file now each image needs to sit inside a single cell and you can see here cell A1 itamp;#39;s actually quite large but the image sits perfectly inside that cell and itamp;#39;s important that the cell is at least as big or slightly bigger than the image because if any part of that image sits outside of the cell youamp;#39;re going to get a distorted result when you look it up so Iamp;#39;m just going to contrl zed to pop that back in now you can see here if I go down to the end Iamp;#39;ve got