WEBVTT Kind: captions Language: en 00:00:11.440 --> 00:00:15.429 Excel worksheets can have a lot of cells, and sometimes you may find that you want to 00:00:15.429 --> 00:00:18.100 view two different parts of the spreadsheet at the same time. 00:00:18.100 --> 00:00:23.740 For example, in this spreadsheet I have a list of salespeople in the first column, but 00:00:23.740 --> 00:00:27.230 when I scroll to the right, those names disappear, which makes it really hard to see who the 00:00:27.230 --> 00:00:30.230 sales data belongs to. 00:00:30.230 --> 00:00:34.840 We can fix this by freezing the first column, so it will always stay visible. 00:00:34.840 --> 00:00:41.200 First, go to the View tab… and click Freeze Panes. 00:00:41.200 --> 00:00:47.059 You have a few different options, but we just want to freeze the first column. 00:00:47.059 --> 00:00:51.019 Now when we scroll, we can easily see the names of each salesperson, no matter where 00:00:51.019 --> 00:00:53.030 we are in the spreadsheet. 00:00:53.030 --> 00:00:58.739 This spreadsheet also has dates in the second row, and I'd like to freeze them so they'll 00:00:58.739 --> 00:01:01.269 stay visible when I scroll down. 00:01:01.269 --> 00:01:05.019 But this time it's going to work a little differently because it's row 2. 00:01:05.019 --> 00:01:08.850 And you can see why if you go to the Freeze Panes command. 00:01:08.850 --> 00:01:13.020 There's an option to freeze the top row, but there isn't an option to just freeze the second 00:01:13.020 --> 00:01:14.330 row by itself. 00:01:14.330 --> 00:01:18.730 Instead, we'll need to freeze the top two rows. 00:01:18.730 --> 00:01:23.650 Since we've already frozen the first column, we'll need to reset the spreadsheet by selecting 00:01:23.650 --> 00:01:26.190 Unfreeze Panes. 00:01:26.190 --> 00:01:28.550 And now, you have two options. 00:01:28.550 --> 00:01:32.720 You can either select the row below the rows that you want to freeze, or you can select 00:01:32.720 --> 00:01:36.040 a single cell, such as B3. 00:01:36.040 --> 00:01:40.711 If you only select one cell, it will freeze the rows above it, and also the columns to 00:01:40.711 --> 00:01:43.730 the left—and that's exactly what we want. 00:01:43.730 --> 00:01:50.410 Next, go to the Freeze Panes command… and select Freeze Panes. 00:01:50.410 --> 00:01:55.640 And now you can see a thin line in between rows 2 and 3, and also a line between columns 00:01:55.640 --> 00:01:58.140 A and B. 00:01:58.140 --> 00:02:02.280 When I scroll, I can see all of my header rows and columns no matter where I am in the 00:02:02.280 --> 00:02:07.310 spreadsheet. 00:02:07.310 --> 00:02:11.360 Sometimes you may need to work with different parts of the spreadsheet at the same time. 00:02:11.360 --> 00:02:13.640 There are a couple of ways to do this. 00:02:13.640 --> 00:02:17.340 One way is to click the New Window command. 00:02:17.340 --> 00:02:21.430 This will give you two separate windows, and you may need to drag the top of each window 00:02:21.430 --> 00:02:26.410 so you can see both of them. 00:02:26.410 --> 00:02:31.040 Both of these windows are showing the same file, and we can use it to view two different 00:02:31.040 --> 00:02:33.190 parts of the worksheet. 00:02:33.190 --> 00:02:39.160 Or, if the workbook has multiple sheets, you can view two of them side-by-side. 00:02:39.160 --> 00:02:44.170 So I could view the 2010 sales in one window, and the 2012 sales in another—which makes 00:02:44.170 --> 00:02:47.580 it very easy to compare the two years. 00:02:47.580 --> 00:02:51.690 If you want to go back to just viewing one window, you close either one by clicking the 00:02:51.690 --> 00:02:54.810 close button in the upper-right corner. 00:02:54.810 --> 00:02:59.920 And then you can resize the window or click the maximize button. 00:02:59.920 --> 00:03:04.250 Another way to view two different parts of a worksheet is to use the split feature. 00:03:04.250 --> 00:03:08.350 This is a little bit like freezing panes, except instead of freezing them, you can actually 00:03:08.350 --> 00:03:11.069 scroll each section individually. 00:03:11.069 --> 00:03:16.870 First, if you have any frozen panes, you'll need to Unfreeze Panes. 00:03:16.870 --> 00:03:22.900 Then, select the cell where you want the split to appear (usually somewhere near the middle)… 00:03:22.900 --> 00:03:26.190 and then click the Split command. 00:03:26.190 --> 00:03:30.270 You can now see that there are vertical and horizontal dividers. 00:03:30.270 --> 00:03:38.580 There are also four scrollbars, which you can use to scroll the different sections. 00:03:38.580 --> 00:03:42.099 Now you may find that this view is a little bit too cluttered, but you can make it simpler 00:03:42.099 --> 00:03:45.110 by removing one of the dividers. 00:03:45.110 --> 00:03:50.820 If you drag the vertical divider all the way to the left… it will disappear, and you'll 00:03:50.820 --> 00:03:54.319 just have a horizontal divider. 00:03:54.319 --> 00:03:59.350 By scrolling the top and bottom sections, we can compare the data for any two salespeople—for 00:03:59.350 --> 00:04:04.570 example, David Carlson and Melissa Post. 00:04:04.570 --> 00:04:08.210 Depending on the spreadsheet, some of these view options may be better than others. 00:04:08.210 --> 00:04:12.680 In this example, the header rows and columns are really important, so the freeze panes 00:04:12.680 --> 00:04:15.360 feature is probably the best choice. 00:04:15.360 --> 00:04:19.660 You'll just have to try all of the view options to see which one works best for your spreadsheet.