WEBVTT Kind: captions Language: en 00:00:09.580 --> 00:00:13.929 Tables are a great way to add more advanced formatting to your worksheets, like banded 00:00:13.929 --> 00:00:19.279 rows, preset color schemes, and other design elements that can save you tons of time. Let's 00:00:19.279 --> 00:00:21.020 take a look. 00:00:21.020 --> 00:00:26.740 To create a table, all you have to do is select the cells you want to include… then click 00:00:26.740 --> 00:00:30.689 the Format as Table command on the Home tab. 00:00:30.689 --> 00:00:34.969 Here you'll find several different styles to choose from. Just pick whichever one appeals 00:00:34.969 --> 00:00:40.059 to you the most—you can always choose a different table style later. 00:00:40.059 --> 00:00:44.030 If you want your table to have special formatting in the header row, make sure you leave this 00:00:44.030 --> 00:00:49.480 box checked. You can also change the selection if you need to. 00:00:49.480 --> 00:00:55.250 When you're ready, click OK… and now we have a table. 00:00:55.250 --> 00:00:59.750 Notice that every table includes filtering by default, which will let you sort your data, 00:00:59.750 --> 00:01:04.549 or narrow it down depending on what you need. You can apply filtering any time using the 00:01:04.549 --> 00:01:08.200 drop-down arrows here. 00:01:08.200 --> 00:01:13.070 If you need to fit more content into your table, not to worry. Excel gives you two ways 00:01:13.070 --> 00:01:17.979 to add more columns or rows in the same style as the rest of the table. 00:01:17.979 --> 00:01:23.509 Just enter your data in any adjacent column or row... and it will be roped into the table 00:01:23.509 --> 00:01:29.220 automatically. You can also click, hold, and drag the bottom right corner to create any 00:01:29.220 --> 00:01:34.460 size table you need. 00:01:34.460 --> 00:01:39.680 This is looking pretty good. I think I'm ready to try some different formatting options now. 00:01:39.680 --> 00:01:43.850 For that, you'll find everything you need on the Design tab, which appears anytime you 00:01:43.850 --> 00:01:46.490 have your table selected. 00:01:46.490 --> 00:01:50.759 Remember how I said you could change your table style once you added one to your worksheet? 00:01:50.759 --> 00:01:55.780 You can do that here using the options in the Table Styles group... and this time, you 00:01:55.780 --> 00:01:57.600 get preview. 00:01:57.600 --> 00:02:02.020 This is one of the benefits of using tables in Excel. They make it easy to change the 00:02:02.020 --> 00:02:06.799 look and feel of your worksheet, and it's a lot faster than formatting the cells yourself. 00:02:06.799 --> 00:02:09.970 Why don't we go with this one? 00:02:09.970 --> 00:02:14.690 Next to the table styles, Excel gives you a few more options for customizing your table. 00:02:14.690 --> 00:02:19.970 For example, you could add special formatting to the last column to make it stand out… 00:02:19.970 --> 00:02:25.200 or you could add a total row. These will all look slightly different depending on the table 00:02:25.200 --> 00:02:30.260 style you've chosen, so you might need to experiment to get the look you want. 00:02:30.260 --> 00:02:34.510 If you change your mind, you can always remove the table from your workbook, without losing 00:02:34.510 --> 00:02:39.400 any of your data. Just be aware that this can cause issues with cell formatting, so 00:02:39.400 --> 00:02:43.030 it should only be done if you truly intend to start over. 00:02:43.030 --> 00:02:47.670 All you have to do is make sure your table is selected, then click Convert to Range on 00:02:47.670 --> 00:02:55.650 the Design tab. Next, click Yes to confirm… and the range will no longer be a table. 00:02:55.650 --> 00:03:01.300 The Design tab has disappeared, but you can still adjust the formatting manually using 00:03:01.300 --> 00:03:06.110 the options on the Home tab. You can even use the Clear command to re-start your formatting 00:03:06.110 --> 00:03:08.250 from scratch. 00:03:08.250 --> 00:03:10.860 Now you know how to add and remove tables in Excel.