🖼️ NEW! Insert Images INSIDE Cells with Excel IMAGE Function

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 ม.ค. 2025

ความคิดเห็น • 74

  • @leiterservices
    @leiterservices 2 ปีที่แล้ว +10

    I tried this today, but it gave a "#name" error. Image link was in column G, image formula in column h. used formula =image(G2)

  • @chh8860
    @chh8860 2 ปีที่แล้ว +14

    Not quite sure how, or when, I will use this feature, but someday down the road I will use it and think, "... thank you, Leila ..."

  • @technicaldata3227
    @technicaldata3227 2 ปีที่แล้ว +1

    As always thank you for sharing 🙏

  • @heidysosa7555
    @heidysosa7555 ปีที่แล้ว

    Love this function! Just wished it worked with onedrive URL links

  • @atulkhaire2856
    @atulkhaire2856 2 ปีที่แล้ว +1

    Is there any separate procedure to enable this function/formula because in normal excel I can not see this formula?

  • @vuhoang7109
    @vuhoang7109 2 ปีที่แล้ว

    Never a dull tutorial from you, Leila! Thank you!🙂

  • @abbashuzefamotiwala
    @abbashuzefamotiwala 2 ปีที่แล้ว

    Please figure out something for dynamic QR code in ms excel just like you taught in Google Sheets course :)

  • @mozgus79ify
    @mozgus79ify 2 ปีที่แล้ว +2

    Great.... Does it open the ability to put QR code there? Like in Google Sheets? Maybe using Google QR code URL? 🤔💡

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว +2

      That would be cool. I haven't tested that.

  • @Not-Only-Reaper-Tutorials
    @Not-Only-Reaper-Tutorials 2 ปีที่แล้ว +2

    Interesting I suppose it will come with some update. Today I have not that function

  • @pavolsvorc7272
    @pavolsvorc7272 2 ปีที่แล้ว

    Excellent! Thanks.

  • @Jc-property
    @Jc-property 2 ปีที่แล้ว +1

    Another great one ! Where do you find the mention and description of those news functions ? I can't find them in the official insider release notes.

  • @robertowens6674
    @robertowens6674 2 ปีที่แล้ว +1

    Dang! I've been trying to create a memory game in Excel and I keep crashing cause I'm trying to set it up with some dynamic images and the memory it uses is huge. This would make it so much easier. I can't wait for this to come out.

  • @seanmahoney2671
    @seanmahoney2671 2 ปีที่แล้ว

    I am excited for this one, but a little disappointed it seems to be pulling just from the web. Is there not an option for an imbedded image that is still inside the cell?

  • @giorgidvali951159
    @giorgidvali951159 2 ปีที่แล้ว

    Love all your videos!!!! Thank you

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว

      You are so welcome! Thank you.

  • @blenderthenrender7465
    @blenderthenrender7465 8 หลายเดือนก่อน

    it seems like it enlarge the image while to pause the cursor, how do you do that? super thanks for everything.

  • @ExcelLagi
    @ExcelLagi 2 ปีที่แล้ว

    Nice tips

  • @rvallenduuk
    @rvallenduuk 2 ปีที่แล้ว

    FINALLY!!!
    This has been one of my favourite Google Sheets functions for years. Why did it take Mickeysoft this long?

  • @yerbolabzhamiyev3268
    @yerbolabzhamiyev3268 2 ปีที่แล้ว

    Leila is teasing us! 😊

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว +1

      😊

    • @yerbolabzhamiyev3268
      @yerbolabzhamiyev3268 2 ปีที่แล้ว

      @@LeilaGharani would you like to give us some tips about MS Project, if you work with this software?

    • @yerbolabzhamiyev3268
      @yerbolabzhamiyev3268 2 ปีที่แล้ว

      @@LeilaGharani how can I ask questions about your training?

  • @dr.moustafael-hammamy5355
    @dr.moustafael-hammamy5355 2 ปีที่แล้ว

    You are great as usual i like your presentations

  • @terrrywhite2113
    @terrrywhite2113 2 ปีที่แล้ว +1

    Very very interesting. I got into all sorts of bloat trouble with a huge colour scheme spreadsheet last year. Is this an efficient way to include images?

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว +1

      I still have to test with lots of images but I think it's definitely better than inserting large images on the grid.

  • @chrism9037
    @chrism9037 2 ปีที่แล้ว +1

    Excellent, looking forward to getting it, thanks Leila!

  • @Saleh.Wardak
    @Saleh.Wardak 2 ปีที่แล้ว

    Nice
    is this formula available in office 2021

  • @elipomerantz6980
    @elipomerantz6980 2 ปีที่แล้ว

    So cool

  • @antoineferrand149
    @antoineferrand149 2 ปีที่แล้ว

    Pretty cool but didn’t try, does it work in an « official excel table » as you usually name it Leila?

  • @Omahaneb6
    @Omahaneb6 2 ปีที่แล้ว

    Interesting. What’s the value of this over pasting image?

    • @brianxyz
      @brianxyz 2 ปีที่แล้ว +1

      This makes the image part of the cell which allows you to sort, add cells, etc.

  • @Teralines
    @Teralines 2 ปีที่แล้ว

    Hi, how to align the image in a cell?

  • @ThexBorg
    @ThexBorg 2 ปีที่แล้ว

    Animated gifs in Outlook emails… them I’m happy

  • @user-wy3xy8xv6u
    @user-wy3xy8xv6u 2 ปีที่แล้ว

    Dear mam, which category use you?

  • @abdulsaidmkamara7305
    @abdulsaidmkamara7305 2 ปีที่แล้ว

    Thanks, Leila, What is office insiders ??

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว +3

      Office insiders is Office 365 that gets sooner updates before they are released publicly. It's the beta channel where Microsoft also monitors feedback to see if there are any bugs and if they should tweak something before they publicly release it. Anyone can join Office insiders if they have a 365 account.

    • @abdulsaidmkamara7305
      @abdulsaidmkamara7305 2 ปีที่แล้ว

      @@LeilaGharani Thank you very much Leila 😊 and have a lovely day.

  • @MohitYadav-995
    @MohitYadav-995 2 ปีที่แล้ว

    Super 👌

  • @pepsakdoek1029
    @pepsakdoek1029 2 ปีที่แล้ว

    Does image return true if the image exist and false if it doesn't? (meaning can I do iferror(image(url1), image(url2))?

  • @winsonlee16
    @winsonlee16 2 ปีที่แล้ว

    Cannot find in office 365. Need update??

  • @GunbladeXBustersword
    @GunbladeXBustersword 2 ปีที่แล้ว

    Where would it be safe to store the images on the web so the link won't suddenly expire and become unuseable when it changes or the source platform disappears?

    • @borstenpinsel
      @borstenpinsel 2 ปีที่แล้ว

      Your own github would probably be the best solution

  • @borstenpinsel
    @borstenpinsel 2 ปีที่แล้ว

    Is this like webservice() point accepting http(s)? Or Dore it work with file:// also

  • @yasserahmed7440
    @yasserahmed7440 2 ปีที่แล้ว

    It doesnot work for local files.why?

  • @Just4u-friends
    @Just4u-friends 2 ปีที่แล้ว

    Any contest?

  • @hubbabt
    @hubbabt 2 ปีที่แล้ว

    only in office365? or regular excel can work too?

  • @djbeste
    @djbeste 2 ปีที่แล้ว

    This is copied from Google sheets (unless Google copied it elsewhere). I am using this to share product lists and have a better impression of the items in it. Good to have this in Excel now, too.

  • @scottperry3124
    @scottperry3124 2 ปีที่แล้ว

    As usual MS adds a good function that has strange limitations. Why does it have to be a web image? If they can do that why not allow insertion of local images into cells the
    Same way? Even better, embedded rather than linked. THAT would be a logical and useful tool.

  • @Cherry_Memory
    @Cherry_Memory 2 ปีที่แล้ว

    베리굿!

  • @BalurPoco
    @BalurPoco ปีที่แล้ว

    I got #BLOCKED! instead of the actual image. How can I fix that?

    • @BalurPoco
      @BalurPoco ปีที่แล้ว

      Found it. Under "Excel options > Trust Center > Trust Center Settings > Privacy Options > Privacy Settings" turn on both "Turn on experiences that analyze your content" and "Turn on experiences that download online content". Restart Excel, I had to wait about 5-10 minutes to start working. Don't know why.

  • @ajayjf
    @ajayjf 2 ปีที่แล้ว

    Thanks for the drop, what version are you using, am on the latest version 2208 15601.20148 though dont seem to have this function, hope its on the next update.

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว

      It's still in Beta. You have to join Office Insider to get it now.

  • @uahnbu
    @uahnbu 2 ปีที่แล้ว

    Add RegExp functions and then Excel will be completed, at least for me 😛

    • @borstenpinsel
      @borstenpinsel 2 ปีที่แล้ว

      Yeah we definitely need way better string manipulation functions

  • @jakubczajczynski2267
    @jakubczajczynski2267 2 ปีที่แล้ว +1

    Nice to have, especially since regular images in tables are broken! Unfortunately, it can't be a link to a local file, but I guess I can store my pictures on OneDrive.

  • @kuatle
    @kuatle 2 ปีที่แล้ว

    Hi, Google Sheets

  • @petr6617
    @petr6617 2 ปีที่แล้ว

    Only https as source? Oh no :-)

  • @anupunja1010
    @anupunja1010 2 ปีที่แล้ว

    it did not work, actually. Is it beta?

    • @anupunja1010
      @anupunja1010 2 ปีที่แล้ว

      I did not find the function, in fact.

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว +1

      It's in beta. It will in beta for some time before it's rolled out to general.

    • @ayyazryk2815
      @ayyazryk2815 2 ปีที่แล้ว

      @@LeilaGharani thanks ma’am

    • @adamtparker6515
      @adamtparker6515 2 ปีที่แล้ว

      Ah, explains why I had to keep the then Oracle Open Source version of Excel, which now has transformed into Google LLC free and paid Open Source versions. if you find a soln that involves import/export of Excel file using Google LLC product then resaving as embedded images within Excel let me know!

    • @Djbram99
      @Djbram99 ปีที่แล้ว

      Oi

  • @Rice0987
    @Rice0987 2 ปีที่แล้ว

    What to do if you are an outsider?😒

    • @LeilaGharani
      @LeilaGharani  2 ปีที่แล้ว

      You can become an insider 😉. It's free for anyone with Office 365.

    • @Rice0987
      @Rice0987 2 ปีที่แล้ว

      @@LeilaGharani Oh, it's so pitty that 2021 doesnt participate in insider program. :( So, i have to just wait for next update...

  • @sonamtseringsherpa
    @sonamtseringsherpa 2 ปีที่แล้ว

    Wooow

  • @tifouraamina1761
    @tifouraamina1761 2 ปีที่แล้ว

    😃