How to Make a Data Table in Google Sheets

Sdílet
Vložit
  • čas přidán 14. 10. 2015

Komentáře • 75

  • @andreapif
    @andreapif Před 4 lety +74

    The data table is different. Select the area you want to turn into a table then DATA -> Filter Views -> Create Filter View

    • @LostMemory1993
      @LostMemory1993 Před 3 lety +11

      So it was of use to open this video. This was the answer I (and probably all the viewers) was looking for. Thank you!!

    • @nn-eq2rt
      @nn-eq2rt Před 3 lety +2

      a Massive thank you!!

    • @cjc793
      @cjc793 Před 2 lety +4

      The video is about making a good looking grid, and it is good lookin... But NOT about creating a "Data Table". Andrea's answer is the correct answer to anyones' question about creating a "Data Table"

    • @vishnukv5251
      @vishnukv5251 Před rokem

      Thank you!!

    • @TheMiig1513
      @TheMiig1513 Před rokem

      Thank you

  • @jimoneill4512
    @jimoneill4512 Před 6 měsíci +2

    This video saved me! I have been trying to make a table for over 5 years! I thot I was incapable able of learning it. Now I see I can just bold the lines and get whatever I want. I was trying to move those silly computer lines, and I could never get my table set up, much less add data to it. This was AMAZING! Thank you SO much. 😊😊😊 I was definitely overthinking it. Thank you for showing all those cool features and how to find them as well. I can't right click on an iPad, but I will look for a workaround for that. You've inspired me!

    • @MrKrabs974
      @MrKrabs974 Před 6 měsíci

      but hoew do i mke atabele? i dtired this and it jdint work?

  • @mydiytutor
    @mydiytutor Před 7 lety +154

    This is not a data table.

    • @damiantoczek4814
      @damiantoczek4814 Před 5 lety

      Sadly it is :) Same as MySQL.

    • @rogeriopenna9014
      @rogeriopenna9014 Před 4 lety

      @@damiantoczek4814 no

    • @pcbingemaster
      @pcbingemaster Před 4 lety +1

      It's a table, and it contains data. So pretty sure this is a "data table"

    • @DrCalviny
      @DrCalviny Před 4 lety +3

      @@pcbingemaster it's not a table, those are Borders.

    • @magne6049
      @magne6049 Před 4 lety +2

      Looking for a Data Table (aka. What-If analysis) in Google Sheets, similar to the one in Excel? Try this github.com/redbar0n/google-sheets-what-if-analysis

  • @Jayimnothere
    @Jayimnothere Před rokem +5

    Thank you for actually showing HOW to make a table from the beginning instead of already having one made.

  • @bellitasophita
    @bellitasophita Před 6 lety +24

    thank you, you made it possible for me to do my hw

    • @Fiqh_4kids
      @Fiqh_4kids Před 7 měsíci

      same,THis was also my homework

  • @xgalaxyone
    @xgalaxyone Před 7 lety +15

    Thank you but can you create similar data tables to MS Excel where rows created automatically not manually by pressing Tab or go to the next row. I guess that is what most of us are looking after! Anyway thankful for your effort :-)

  • @zdrgnjil3908
    @zdrgnjil3908 Před 3 lety +2

    Thank you! You really helped me :)

  • @CatherinCooper
    @CatherinCooper Před 4 lety +3

    Thank you so much for this tutorial. I have never been good with spreadsheets. This has helped me tremendously.

  • @erickelizalde2
    @erickelizalde2 Před 3 lety +2

    Thank you! Great video.

  • @Rogueblue
    @Rogueblue Před rokem

    SUPER HELPFUL! Thank you sooooo much for making this video

  • @J0hnJ3ans
    @J0hnJ3ans Před 3 lety +3

    thanks for giving me an A on my assignment :D

  • @killrIndustries
    @killrIndustries Před 2 lety

    BEST TEACHER EVER!

  • @pixeladagency1870
    @pixeladagency1870 Před 4 lety +1

    Not what i came looking for but learn few things about Sheets which i wasn't aware of.
    Thanks :)

    • @magne6049
      @magne6049 Před 4 lety

      Looking for a Data Table (aka. What-If analysis) in Google Sheets, similar to the one in Excel? Try this github.com/redbar0n/google-sheets-what-if-analysis

  • @pricedingson2114
    @pricedingson2114 Před 4 lety +1

    I actually don't know how to create a table using google sheets, then I found this video. Thank you so much! This is helpful!

  • @jessicavitangcol4013
    @jessicavitangcol4013 Před 3 lety

    Thank you so much!!

  • @sh0k3_30
    @sh0k3_30 Před 3 lety +1

    thank you!

  • @aldoalbar3516
    @aldoalbar3516 Před 6 lety +12

    Seriously ... !!??

  • @nicestes4482
    @nicestes4482 Před rokem

    Thanks helped a lot 😊

  • @johngooch8509
    @johngooch8509 Před 5 lety

    Thanks for this simple science data and formula answer table making with google sheet intro.
    It is a bless for beginners and God like this frustration reduction.

  • @mikelicious33
    @mikelicious33 Před 5 lety +1

    Thank you! That was very helpful

  • @azalea1718
    @azalea1718 Před 2 lety

    700th like! thx for this video

  • @user-bu8co2hy8e
    @user-bu8co2hy8e Před 4 měsíci

    thank u dear iam from india help full video

  • @rheajobin06
    @rheajobin06 Před 2 lety

    Thank you for the explanation... please update i want learn more things about you....

  • @bbgigi3358
    @bbgigi3358 Před 4 lety

    THANK YOU! THIS HELPED A LOT

  • @romaarmy123
    @romaarmy123 Před rokem

    omg u saved me
    thankuu

  • @Landonouis
    @Landonouis Před 7 měsíci

    Very helpful thank you.

  • @SakshiSood-jq3bc
    @SakshiSood-jq3bc Před rokem

    best explanation

  • @Theislandpoet
    @Theislandpoet Před 6 lety +9

    so much useless information. This is a beginners tour to google sheets not how to make a data table. you might as well do this by hand with cave drawings.

  • @hookey24
    @hookey24 Před 5 lety +4

    That's not a data table

  • @krishnagangwal5792
    @krishnagangwal5792 Před rokem

    thanks bhai

  • @amtechnology9328
    @amtechnology9328 Před 4 lety

    NICE

  • @francelinoximenes9497
    @francelinoximenes9497 Před 4 lety

    Data table....!!!! I'm not sure with this, but I call this as a simple table on a google sheet or excel.

  • @epicduelqueen
    @epicduelqueen Před 2 lety

    To all the people thumbing down dunno what you're smoking but this is a nice beginner level tutorial.

  • @Layarion
    @Layarion Před 4 lety

    didn't mention freezing things in place

  • @kidsavy380
    @kidsavy380 Před 3 lety

    Thank you

  • @derekhollingsworth9639
    @derekhollingsworth9639 Před 4 lety +8

    Ditto, Ditto, ditto...you just wasted 10 minutes of my time...This is NOT a Data Table!!!!!!!!!!!

  • @misha1004
    @misha1004 Před rokem

    Thankyou😊😊😊

  • @hailey7712
    @hailey7712 Před 5 lety +2

    Omg you are a life saver! All of the videos I watched did not help at all. Now I can finish my science fair project!

  • @andre-tt3pp
    @andre-tt3pp Před 4 lety

    This is no table.

  • @Tay-ky3fi
    @Tay-ky3fi Před 4 lety

    im sorry this is a table.. not a DATA table.. people are looking for excel's version of data table.

  • @IgnacioJoannon
    @IgnacioJoannon Před 2 lety

    This is not a Data Table as in Excel

  • @ashutosh676
    @ashutosh676 Před 4 lety +1

    u should 1st learn the meaning of TABLE

  • @jaddehna5325
    @jaddehna5325 Před 6 lety

    hehehehheeee

  • @arielfierro7089
    @arielfierro7089 Před 2 lety

    That is not a table

  • @mydiytutor
    @mydiytutor Před 3 lety +2

    This is not a Data Table. Wrong terminology.
    A table with data - yes. But Data Table - no.
    Example of Data Table in Excel: www.excel-easy.com/examples/data-tables.html

  • @keenangsc8130
    @keenangsc8130 Před 3 lety +1

    thanks for wasting my time

  • @actiecommissiecgknoordeloo103

    This is so lame. Made this when I was 3 years old.

  • @jgraphis
    @jgraphis Před 4 lety +1

    That's not a data table