Excel - Multiple Hyperlinks in one Cell | Add Different Hyperlinks to Words Within the Same Cell

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024
  • In this Microsoft Excel video tutorial I explain how to add multiple hyperlinks within a single cell. We want different hyperlinks can be added to different words within a cell. Although Excel doesn't support this functionality there is an easy workaround using shapes.
    #microsoftexcel #hyperlinks #exceltutorial #exceltips

Комментарии • 32

  • @EntropiaOrganizada
    @EntropiaOrganizada 7 месяцев назад +18

    A tremendously complicated solution for something that Excel should be able to do by default... totally brilliant too!

  • @fjshaw7392
    @fjshaw7392 Месяц назад

    Brilliant. Thank you for saving both my head and a brick wall.

  • @hans-martinjack9609
    @hans-martinjack9609 9 месяцев назад +1

    Well done. Very good idea to get around the problem

  • @echologged85
    @echologged85 2 месяца назад

    Great work around! Thank you for sharing this video! Now if Microsoft would actually make it possible to do that without having to do this workaround...

  • @lakhdarzeghib6068
    @lakhdarzeghib6068 Год назад +1

    what if the form of the cell has changed , will be attached to work , I dont think so ?

  • @Ritterkritterz
    @Ritterkritterz Год назад +1

    thank you!!!! Been trying for 3 hours so that all the font on the cell will not be a link, -just a few words. TY TY TY!!!!!

  • @jopadjr
    @jopadjr Год назад

    82nd...Thanks Chester !!! Great that I found you mate...

  • @lompocbg
    @lompocbg 9 месяцев назад +1

    Thanks , man! Really healpful!!!

  • @samueltaylor9078
    @samueltaylor9078 Месяц назад

    Awesome solution - thank you:)

  • @RehillServices-g3z
    @RehillServices-g3z Месяц назад

    but if i create pdf from this file, the links are not working. pl guide

  • @Hossein_ghanaei
    @Hossein_ghanaei 10 месяцев назад

    That was very helpful. Thanks.

  • @JDFrancis
    @JDFrancis 6 месяцев назад

    Works like a charm.

  • @mujahidazeemi3023
    @mujahidazeemi3023 5 месяцев назад

    you are brilliant sir

  • @matthewkonkol6717
    @matthewkonkol6717 Год назад +4

    Too bad there isn't a fix for the cell resizing issue.

  • @jassbrar408
    @jassbrar408 Год назад

    Thank you so much. I do have a follow up question, lets say I added 2 hyperlinks from B300 & C250 to H550. I inserted a row between 300 & 250. This changes the Hyperlink. Can this be fixed ?

    • @lompocbg
      @lompocbg 9 месяцев назад

      If you hold ctrl and click on the shape it will be mark and you can move it freely whereever you like and change the size. Think about this like independent layer on the top of the sheets.

  • @MiRofek
    @MiRofek Год назад

    Nice trick! Excellent. Thanks.

  • @karenanderson4639
    @karenanderson4639 8 месяцев назад

    Awesome. You rock!

  • @thuytienlives8487
    @thuytienlives8487 Год назад

    This is really helpful, thank you!

  • @sourabhkumarsingh9648
    @sourabhkumarsingh9648 7 месяцев назад

    really helpful

  • @luliguzman8749
    @luliguzman8749 14 дней назад

    Thanks :)

  • @alexrosen8762
    @alexrosen8762 Год назад

    Great tip! Thank you 🙏

  • @rollacoaster421
    @rollacoaster421 2 месяца назад

    Brilliant!

  • @newtonoluoch8103
    @newtonoluoch8103 5 месяцев назад

    What happens when you resize the cell?

  • @frommyphonesgallery
    @frommyphonesgallery 7 месяцев назад

    Not working on Excel web

  • @mrwho995
    @mrwho995 Месяц назад

    Absolutely baffling that something so simple requires something so convoluted!

  • @user-pj2iq6yh9x
    @user-pj2iq6yh9x 9 месяцев назад

    genius

  • @GeekinTX
    @GeekinTX Год назад +1

    Ha! And they said it couldn't be done. 🙂

  • @NinoBrownBoxing
    @NinoBrownBoxing 8 месяцев назад

    🥲