Excel Tricks - Quickly Fill Series of Numbers in Excel

Поделиться
HTML-код
  • Опубликовано: 17 окт 2024
  • In this tutorial i will teach you how to fill series of numbers easily ang faster in MS Excel.....

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

  • @happyyarnvlog4300
    @happyyarnvlog4300 20 дней назад

    New subscriber po,baguhan Lang po ako s pag gamit NG computer kya malaki tulong s akin to video nyo po, salamat po

  • @TherainH
    @TherainH 2 года назад +2

    napaka helpful po ang video na ito thank you for sharing..pls share how to add cells na hindi magagalaw yung other cells po thank you

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

    Salamat sa sa tutor boss, may bago ako natutunan.

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

    Thank you po.malaking tulong.

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

    Hi I'm trying to do 00000 through 97999 in one colum. But am having so much trouble. Can you please help?

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

      just follow the 2nd step sir fill series start with step value 1 and stop value is 97999... give it a try

  • @timeless8757
    @timeless8757 2 года назад +3

    How to write no. From 100 to 1 . Reverse of no.?? Pls suggest

  • @istoryaheeph
    @istoryaheeph 3 года назад +1

    Hi po, ask lang po yung excel ko kase walang fill series option. unable po yung fill > series option ko

  • @dorkoist1630
    @dorkoist1630 2 года назад +1

    sir paano po if nka merge cells po at hndi po same size yong cell?

  • @Miko-zk8zz
    @Miko-zk8zz 7 месяцев назад +1

    Paano po Sir kung ganito, halimbawa: 0001-2024 sa 0001 po ang series ng number. Salamat in advance.

    • @JLMTv1
      @JLMTv1  7 месяцев назад +1

      ilagay nyo lang po sa step value nya 0001 then sa stop value is 2024

    • @Miko-zk8zz
      @Miko-zk8zz 7 месяцев назад

      @@JLMTv1 Salamat Sir.

    • @Miko-zk8zz
      @Miko-zk8zz 7 месяцев назад

      ​@@JLMTv1ayaw po Sir. Bale ganito po sana 0001-2024, 0002-2024 etc...

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

    Thanks sa tips

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

    Sir paano pag same word na nman ilagay sa 1 to 10 column?

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

    Thankyouu po

  • @nefathegreat9365
    @nefathegreat9365 3 года назад +1

    Paano kung may column part na May space? At lalagdawan mo sya para icontinue ang numbering sa next column

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

      ilagay mo lang yung next 2 number sa column na yun maam then katulad lang nung ginawa mo sa unang column Ex sa first column nag start ka sa 1,2 and it end in 10 if you want to continue it in the next column put the 1st and second number in
      the next column continuation of the last number in the 1st column which is 11,12...

  • @Cheeluna
    @Cheeluna 4 месяца назад

    May other option pa po try nyo guys
    Example =sequence(500)
    Napaka Dali na po

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

    THANK YOU

  • @_Uzbek_Sila_N1_
    @_Uzbek_Sila_N1_ 2 года назад +1

    Thank you

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

    Ser paano po yung auto count rows kpag nagdelete ka ng isang bar

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

      DI mag aajust yung counting sir ma skip yung tatanggalin gagamit ka sir ng =ROW() function para mag auto adjust yun number pag nag delete ka ng row(s).

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

    Sir buha kapa 😅 paano by cell sir like A to D bali puputlin ko yong counting ilipat sa next cell sana buhaay kapa 😢 ang tagal na nito

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

    pano po pag may na nakahide na column

  • @ledelynsantos4008
    @ledelynsantos4008 2 года назад +1

    Thanks you 👏

    • @JLMTv1
      @JLMTv1  2 года назад

      Welcome.

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

    Napakahelpful

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

    how to fast delete?

  • @venkat-te4np
    @venkat-te4np 2 года назад

    THANK U

    • @JLMTv1
      @JLMTv1  2 года назад

      You're welcome!

  • @rizmanmervinadre5352
    @rizmanmervinadre5352 3 года назад +1

    Bat ganun sakin upto 20 ayaw talaga promise

  • @jimmyfernandez2486
    @jimmyfernandez2486 2 года назад +1

    Ayaw naman po yung fill series

  • @nefathegreat9365
    @nefathegreat9365 3 года назад +1

    Hello