Name Ranges Trick to Leave Funny Easter Eggs in Excel

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • Join 300,000+ professionals in our courses: www.xelplus.co...
    I'll show you how you can leave hidden messages and easter eggs in your Microsoft Excel file using Excel Name manager and named ranges.
    🌍 My Online Excel Courses ► www.xelplus.co...
    🎬 LINK to more UA-cam Shorts videos: • Shorts (Tips, Tricks &...
    👕☕ Get the Official XelPlus MERCH: xelplus.creato...
    🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
    📚 Excel RESOURCES I Recommend: www.xelplus.co...
    🎥 GEAR I use: www.xelplus.co...
    More resources on my Amazon page: www.amazon.com...
    🚩Let’s connect on social:
    Instagram: / lgharani
    Twitter: / leilagharani
    LinkedIn: / leilagharani
    👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
    #Excel

КОМЕНТАРІ • 30

  • @antique-bs8bb
    @antique-bs8bb Рік тому +15

    Brilliant, 30 years into Excel and I didn't know that.

  • @Rice0987
    @Rice0987 Рік тому +16

    If you reading this message, then you have zoom out to much.🤗

  • @rwfrench66GenX
    @rwfrench66GenX Рік тому +1

    Thanks for this tip! At a previous job I used a lot of named ranges and I would use foods in alphabetical orders like apple, banana, carrot and so on to keep track of what sheet the range was on. Now I’m going to start zooming out on reports I receive to see if anyone is creating Easter Eggs! 😃

  • @Rice0987
    @Rice0987 Рік тому +3

    I like other cool stuff in named range - you can use it as dynamic!
    Very great and very thanks!😘

    • @LeilaGharani
      @LeilaGharani  Рік тому +2

      Thanks for watching, John!

    • @Rice0987
      @Rice0987 Рік тому +1

      @@LeilaGharani i'm also learning from you!😊

  • @flourishwithMJ
    @flourishwithMJ Рік тому

    Thanks.❤

  • @lorifabian
    @lorifabian Рік тому +1

    It doesn't seem to work in new workbook, but it does when using another sheet in same workbook

  • @Star_boy369
    @Star_boy369 Рік тому +1

    How do you edit or delete the messages once created?

  • @prathameshbile5865
    @prathameshbile5865 Рік тому

    Thank You! Best wishes.

  • @AlexisPerez1
    @AlexisPerez1 Рік тому +1

    This is brilliant. I've zoom enough to see the names, but never crossed my mind using it as an Easter egg. I'd put quotes from scary movies... Which would last until my manager calls me because an accountant on a Friday at 9:00 PM reconciling accounts to close a month almost died from a heart attack because he zoomed and the message "I know what you did last summer" appeared on their monitor.

  • @JackDaniels-xq2hu
    @JackDaniels-xq2hu Рік тому

    I learn that zoom out 20+ years ago when I wanted to see how big my data was, or when I was arranging my tables to be printed in few pages

  • @channelparadize5972
    @channelparadize5972 Рік тому

    You are awesome❤❤

  • @madjack9283
    @madjack9283 Рік тому +2

    But where is Michael 😅

  • @pavelpyshkov7668
    @pavelpyshkov7668 Рік тому

    Super!!!

  • @dfxd
    @dfxd Рік тому

    I've never zoomed out far enough to notice this.

  • @TheElkster
    @TheElkster Рік тому

    I've tried zooming out but cannot see anything😢

  • @lilicai138
    @lilicai138 Рік тому

    Hi, how did you format the worksheet name into a color bubble, so nice!

  • @mohan_dass
    @mohan_dass Рік тому

    Is it possible to do the same thing like saving a picture to be used multiple times like the list?

  • @allisonisis
    @allisonisis Рік тому +1

    Wow. This is cool, but what kind of trouble would it save someone? Lol

  • @dharmmu
    @dharmmu Рік тому

    Great...

  • @user-gl5qd6cz6r
    @user-gl5qd6cz6r Рік тому

    can we count attendance if we use multipul shift in a cell like cell a1 contains abc shift how we count and remaining cell have P and some have aB etc plz replay at urgent

  • @phylectures2023
    @phylectures2023 Рік тому

    Not working in my google sheets

  • @carlwummel9050
    @carlwummel9050 Рік тому

    At least creative 😊

  • @Excellearn_ir
    @Excellearn_ir Рік тому

    😍👌 wow

  • @hemvaidya
    @hemvaidya Рік тому

    wow

  • @nisarg79
    @nisarg79 Рік тому

    Hello Madam,
    It is not working in excel official table SPILL error is there, please suggest solution to use this tips in excel official table.

  • @subratpanda894
    @subratpanda894 Рік тому +1

    op

  • @Satyendra2022
    @Satyendra2022 Рік тому +1

    𝗜 𝗰𝗮𝗻'𝘁 𝘂𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱😉😉 𝗰𝗮𝗻 𝘆𝗼𝘂 𝗲𝘅𝗽𝗹𝗮𝗶𝗻 𝗶𝗻 𝗵𝗶𝗻𝗱𝗶 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲👄💬👄💬