How To Make a Table in Google Sheets

0:00 You're going to learn how to make a table fresh without existing data in this video. In the past video I showed you that you can take existing data , right click, and you can convert to table . But sometimes we want to create a table from scratch or brand new and this is how you do it. So we're going to create a new tab here. You can start typing at table and find tables and here we can insert any of the Featured tables here, we have event planning, customer relations, project management. But let's, in our case, create a blank table . Each of these columns, we can double click and name. Let's put name here and sales here. We can rename the table by double clicking on the table name and saying sales data. And we can also put in Data validation, which includes something Create a new Spreadsheet from just a Name in a Sheet. How To Insert Row Under Header Automatically

0:47 like a drop down menu if we want to select from certain people. Andy, Dwight, and Jim. Click done, and now we have a drop down for the person's names. Sales, we can also make sure that we always enter a number . This is data validation , making sure it is a number . So we don't say something like none. We have a little error here that says invalid must be a number . Okay. 55 or if somebody types in 25, this is not a number we need to actually have the number 25. We can also add more and more interesting elements to this table. We can add different things like a checkbox and say, Approved for bonuses. And if they are approved, there it is. Can add more than one dropdown. We can add another dropdown here for January, February, add another item. Create a Self-Adding Dropdown Menu Are Google Sheets sexy now? Dropdown Chips might do the trick! You Should Know The Limitations of Data Validation

1:36 March. We can add all the months here and here we go. We got January's numbers. We get Andy did 56 in February. In February. There, and we have now created a table from scratch without existing data , and we can create any number of these tables on any number of tabs. We can also select a certain amount of data here, and we can convert to a table here. We can have multiple tables on the same sheet or on the same tab, but personally, for my personal taste, I like to create a new table for each sheet, so that it is very easy to navigate. Instead of the sales data name being here, I put the sales data here on the tab. If you want to get more out of Google Sheets than you ever have before, consider subscribing here on YouTube to better sheets. What is this Ampersand Doing in Google Sheets? Figure Out Frequency of Numbers Big Year - a Whole Year in One Google Sheets Tab Create a Tab for Every Month in Google Sheets with Apps Script