Insert a date picker in Excel without add-ins - Excel Tips and Tricks

Поделиться
HTML-код
  • Опубликовано: 20 сен 2024
  • Learn how to insert a date Picker in Excel without add ins.
    To insert a date picker in Excel without add-ins, you can use Excel's built-in Data Validation feature. To create a date picker in Excel without any add-in, go to the cell where you want the date, click on the Data tab, select Data Validation, and choose Date under the Allow section. This method allows you to make a date picker in Excel by setting a date range for the user to select from. If you are using Excel 365, it does not come with a built-in date picker, but you can still create a date drop-down in Excel using Data Validation. This approach lets you have an Excel date picker without needing VBA or any add-ins, making it simple and accessible.
    At the end of this video, you should be able to answer the following questions
    How do I insert a date picker in Excel without add-ins?
    Create a date picker in #Excel without any add-in
    How do you make a date picker in Excel?
    Does Excel 365 have a date picker?
    How do I insert a date drop-down in Excel?
    Need Excel Date Picker Without VBA or any Add-ins
    #shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

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

  • @Mac-ti5un
    @Mac-ti5un 3 месяца назад +2

    To anyone who is confused, this only works in Microsoft 365 web version.

  • @LivingGuy484
    @LivingGuy484 3 месяца назад +2

    What version are you using that works?

    • @RabiGurungXybernetics
      @RabiGurungXybernetics  3 месяца назад +1

      I should have mentioned this in the video.
      This works in Microsoft 365 only.
      If you want data picker for standalone Excel, I have another video demonstrating that.
      Link as provided below.
      I hope that helps.
      How do I make my Excel calendar pop up for multiple columns? - Excel Tip and Tricks
      ruclips.net/user/shortsNco59X0FSow?si=LxNJZYihhvs8hMY4

  • @JKiler1
    @JKiler1 3 месяца назад +1

    It doesn't work for me either. Using Excel 365.

    • @RabiGurungXybernetics
      @RabiGurungXybernetics  3 месяца назад +1

      I should have mentioned this in the video.
      This works in Microsoft 365 only.
      If you want data picker for standalone Excel, I have another video demonstrating that.
      Link as provided below.
      I hope that helps.
      How do I make my Excel calendar pop up for multiple columns? - Excel Tip and Tricks
      ruclips.net/user/shortsNco59X0FSow?si=LxNJZYihhvs8hMY4

  • @Anger21
    @Anger21 4 месяца назад +2

    Does not work! What could be the reason?

    • @sebrahim_t
      @sebrahim_t 3 месяца назад +1

      Version of excel

    • @RabiGurungXybernetics
      @RabiGurungXybernetics  3 месяца назад +1

      I should have mentioned this in the video.
      This works in Microsoft 365 only.
      If you want data picker for standalone Excel, I have another video demonstrating that.
      Link as provided below.
      I hope that helps.
      How do I make my Excel calendar pop up for multiple columns? - Excel Tip and Tricks
      ruclips.net/user/shortsNco59X0FSow?si=LxNJZYihhvs8hMY4

    • @RabiGurungXybernetics
      @RabiGurungXybernetics  3 месяца назад +1

      I should have mentioned this in the video.
      This works in Microsoft 365 only.
      If you want data picker for standalone Excel, I have another video demonstrating that.
      Link as provided below.
      I hope that helps.
      How do I make my Excel calendar pop up for multiple columns? - Excel Tip and Tricks
      ruclips.net/user/shortsNco59X0FSow?si=LxNJZYihhvs8hMY4

    • @Anger21
      @Anger21 3 месяца назад

      @@RabiGurungXybernetics hello Rabi
      Nop, I have 365 updating version and does not work this short date! 😅

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 месяца назад

    No sir its not working I am also working in office 365 sir
    Your link unable to copy sir

  • @christiancoronado
    @christiancoronado 3 месяца назад

    Not working yet

  • @mpfiesty
    @mpfiesty 3 месяца назад +1

    Aint working breh

    • @RabiGurungXybernetics
      @RabiGurungXybernetics  3 месяца назад +1

      I should have mentioned this in the video.
      This works in Microsoft 365 only.
      If you want data picker for standalone Excel, I have another video demonstrating that.
      Link as provided below.
      I hope that helps.
      How do I make my Excel calendar pop up for multiple columns? - Excel Tip and Tricks
      ruclips.net/user/shortsNco59X0FSow?si=LxNJZYihhvs8hMY4