How to find hidden links and URLs in Excel 2016

Поделиться
HTML-код
  • Опубликовано: 10 июл 2018
  • Hidden links and URLs in Excel 2016 (and previous versions) are what this video is about. Have you had a workbook with multiple pages and forget where you placed your links or hid them on purpose? What about when you're debugging a model that you made or the end dashboard and graphs and you forgot where you placed the URL or link?
    Get a free stock like Apple, Exxon Mobil, GM, Ford, Tesla or Facebook worth up to $500 just by signing up and joining Robinhood using my link: join.robinhood.com/davidm16707
    Watch this video it's just for you! You will no longer have to worry about where that link is, show you exactly how to find it! I also show you how to find it even if you reworded it or renamed it or if it's something other than a regular URL. I show you several different ways to find it and then I actually walk you through finding five different URLs or links.
    I also give you tips going forward to make your links and URLs easier to find!
    Just watch this video and it shows exactly how to do this and to do it very quickly. It also doesn't matter how big your Excel worksheet is or how many sheets that are attached to it or even how many macros are in the workbook. This works regardless and will find you your links or URLs.
    I hope you found this entertaining and helpful!
    Please like and subscribe she can see all my other great videos I have coming out! Plus be sure and check out my channel I have a lot of great videos out there on everything from Excel tricks, to data science, data analysis and more!
    Thanks again and God bless!

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

  • @sant0025
    @sant0025 4 года назад +3

    Thanks. But what would be really useful would be to show how you CAN search within hyperlinks. I'm sure this could be done with VBA. I watched the video hoping for an easy way to get there! Spoiler alert: the video doesn't answer that question, just the question of how to find values in hidden columns/rows.

  • @RonaldRGomes
    @RonaldRGomes 3 года назад

    Thanks for the video, much helpful.
    what if the file is created by someone else & you don't know the name or what is mentioned in that particular cell with hyperlink? The only reference can be viewed from Data> Edit Links option. But then again, it is not allowing you to break or remove the link.
    I have exactly this situation and can't get rid of this hyperlink. I have removed all the names from name manager, but still..
    any suggestions please?