WEBVTT Kind: captions Language: en 00:00:11.410 --> 00:00:15.700 Tables are a great way to add more advanced formatting to your worksheets, like banded 00:00:15.700 --> 00:00:20.990 rows, preset color schemes, and other design elements that can save you tons of time. 00:00:20.990 --> 00:00:23.020 Let's take a look. 00:00:23.020 --> 00:00:28.539 To create a table, all you have to do is select the cells you want to include… then click 00:00:28.539 --> 00:00:32.689 the Format as Table command on the Home tab. 00:00:32.689 --> 00:00:35.390 Here you'll find several different styles to choose from. 00:00:35.390 --> 00:00:39.640 Just pick whichever one appeals to you the most—you can always choose a different table 00:00:39.640 --> 00:00:42.059 style later. 00:00:42.059 --> 00:00:45.850 If you want your table to have special formatting in the header row, make sure you leave this 00:00:45.850 --> 00:00:47.460 box checked. 00:00:47.460 --> 00:00:51.420 You can also change the selection if you need to. 00:00:51.420 --> 00:00:57.290 When you're ready, click OK… and now we have a table! 00:00:57.290 --> 00:01:01.750 Notice that every table includes filtering by default, which will let you sort your data, 00:01:01.750 --> 00:01:04.390 or narrow it down depending on what you need. 00:01:04.390 --> 00:01:10.320 You can apply filtering anytime using the drop-down arrows here. 00:01:10.320 --> 00:01:13.970 If you need to fit more content into your table, not to worry. 00:01:13.970 --> 00:01:18.570 Excel gives you two ways to add more columns or rows in the same style as the rest of the 00:01:18.570 --> 00:01:19.630 table. 00:01:19.630 --> 00:01:28.130 Just select a cell in the last column or row, then start typing in a new cell… 00:01:28.130 --> 00:01:32.430 Or you can click, hold, and drag the bottom right corner of the table to create any size 00:01:32.430 --> 00:01:37.170 you need. 00:01:37.170 --> 00:01:38.280 This is looking pretty good. 00:01:38.280 --> 00:01:42.330 I think I'm ready to try some different formatting options now. 00:01:42.330 --> 00:01:46.411 For that, you'll find everything you need on the Design tab, which appears anytime you 00:01:46.411 --> 00:01:49.220 have your table selected. 00:01:49.220 --> 00:01:53.470 Remember how I said you could change your table style once you added one to your worksheet? 00:01:53.470 --> 00:01:58.420 You can do that here using the options in the Table Styles group—and this time, you 00:01:58.420 --> 00:02:00.350 get preview. 00:02:00.350 --> 00:02:02.979 This is one of the benefits of using tables in Excel. 00:02:02.979 --> 00:02:07.130 They make it easy to change the look and feel of your worksheet, and it's a lot faster than 00:02:07.130 --> 00:02:09.420 formatting the cells yourself. 00:02:09.420 --> 00:02:12.640 Why don't we go with this one? 00:02:12.640 --> 00:02:17.240 Next to the table styles, Excel gives you a few more options for customizing your table. 00:02:17.240 --> 00:02:22.720 For example, you could add special formatting to the last column to make it stand out… 00:02:22.720 --> 00:02:25.420 or you could add a total row. 00:02:25.420 --> 00:02:29.350 These will all look slightly different depending on the table style you've chosen, so you might 00:02:29.350 --> 00:02:33.050 need to experiment to get the look you want. 00:02:33.050 --> 00:02:37.130 If you change your mind, you can always remove the table from your workbook, without losing 00:02:37.130 --> 00:02:39.760 any of the formatting or the data. 00:02:39.760 --> 00:02:44.330 You will lose some functionality, though—like table styles and filtering—so keep this 00:02:44.330 --> 00:02:47.710 in mind before you go through with the steps. 00:02:47.710 --> 00:02:52.220 All you have to do is make sure your table is selected, then click Convert to Range on 00:02:52.220 --> 00:02:54.140 the Design tab. 00:02:54.140 --> 00:03:01.630 Next, click Yes to confirm… and the range will no longer be a table. 00:03:01.630 --> 00:03:05.910 The Design tab has disappeared, but you can still adjust the formatting manually using 00:03:05.910 --> 00:03:09.050 the options on the Home tab. 00:03:09.050 --> 00:03:11.480 Now you know how to add and remove tables in Excel.