WEBVTT Kind: captions Language: en 00:00:07.960 --> 00:00:12.980 Excel worksheets can have a lot of cells and sometimes you may find that you 00:00:12.980 --> 00:00:17.849 want you to different parts of the spreadsheet at the same time. For example, 00:00:17.849 --> 00:00:21.790 in this spreadsheet I have a list of sales people in the first column but 00:00:21.790 --> 00:00:26.079 when I scroll to the right those names disappear ,which makes it really hard to 00:00:26.079 --> 00:00:28.610 see who the sales data belongs to. 00:00:28.610 --> 00:00:33.080 We can fix this by freezing the first column so it'll always take visible. 00:00:33.080 --> 00:00:39.380 First go to the View tab and click Freeze Panes 00:00:39.380 --> 00:00:44.850 and you have a few different options but we just want to freeze the first column. 00:00:44.850 --> 00:00:49.670 Now when we scroll, we can easily see the names of each salesperson no matter 00:00:49.670 --> 00:00:51.829 where we are in the spreadsheet. 00:00:51.829 --> 00:00:56.140 This worksheet also has dates in the second row and I'd like to freeze them 00:00:56.140 --> 00:01:00.239 to stay visible when I scroll down, but in this example it's going to 00:01:00.239 --> 00:01:04.129 work a bit differently and that's because it's row 2. 00:01:04.129 --> 00:01:07.690 You can see why if I go to the Freeze Panes command. 00:01:07.690 --> 00:01:11.940 There's an option to freeze the top row, but there isn't an option to freeze just 00:01:11.940 --> 00:01:17.860 the second row by itself; instead we'll need to freeze the top two rows. Since we've 00:01:17.860 --> 00:01:21.870 already frozen the first column, we will first need to reset the spreadsheet by 00:01:21.870 --> 00:01:27.910 selecting Unfreeze Panes, and now you have two options; you can either select 00:01:27.910 --> 00:01:33.470 the row below the row want to freeze— that's row 3 in this case—or you can 00:01:33.470 --> 00:01:39.430 select a single cell such as B3. If you select only one cell, it will freeze the 00:01:39.430 --> 00:01:45.810 rows above it, and also any columns to the left, and that's exactly what we want here. 00:01:45.810 --> 00:01:51.100 Next, go to the Freeze Panes command and select Freeze Panes 00:01:51.100 --> 00:01:56.470 Now you can see a think line between rows 2 and 3 and also in-between 00:01:56.470 --> 00:02:02.280 columns A and B. When I scroll I, can see all of my headers data, no matter 00:02:02.280 --> 00:02:04.520 where I am in the spreadsheet. 00:02:04.520 --> 00:02:08.269 Sometimes you may need to work with different parts of the spreadsheet at 00:02:08.269 --> 00:02:12.930 the same time. There are a couple of ways to do this. One is to click the New 00:02:12.930 --> 00:02:17.090 Window command on the View tab. This will give you two separate windows and you 00:02:17.090 --> 00:02:22.940 may need to rearrange them so that you can do both at the same time. 00:02:22.940 --> 00:02:26.920 These windows are showing the same file and we can use it to view to different 00:02:26.920 --> 00:02:31.290 parts of the worksheet. for example, if the workbook has multiple sheets ,you can 00:02:31.290 --> 00:02:36.850 view two of them side by side, so I could be the 2013 sales in one window and the 00:02:36.850 --> 00:02:42.170 2014 sales in another, which makes it very easy to compare the two years. 00:02:42.170 --> 00:02:46.120 If you want to go back to just one window, you can close either one by 00:02:46.120 --> 00:02:50.239 clicking the close button in the upper-right corner .You can then resize 00:02:50.239 --> 00:02:53.730 the window if needed, or just click the Maximize button. 00:02:53.730 --> 00:02:57.739 Another way to view to different parts of a worksheet is to use the Split feature. 00:02:57.739 --> 00:03:02.620 This i s a little bit like freezing panes, except instead of freezing them 00:03:02.620 --> 00:03:06.880 you can actually scroll each section independently. 00:03:06.880 --> 00:03:11.580 First, if you have any frozen panes, you'll need to go back to the Freeze Panes 00:03:11.580 --> 00:03:15.030 command then choose Unfreeze Panes. 00:03:15.030 --> 00:03:19.440 Then, select a cell where you want the split to appear, usually somewhere near the 00:03:19.440 --> 00:03:23.330 middle of your spreadsheet, and then click the Split command. 00:03:23.330 --> 00:03:27.310 And now you can see it there are vertical and horizontal divides. 00:03:27.310 --> 00:03:32.590 There are also four scrollbars, which we can use to scroll the different sections. 00:03:32.590 --> 00:03:36.340 If you find that this view is a little bit too cluttered, you can make it 00:03:36.340 --> 00:03:39.260 simpler by removing one of the dividers. 00:03:39.260 --> 00:03:43.470 If you drag the vertical divider all the way to the left, it will disappear 00:03:43.470 --> 00:03:46.200 and you just have a horizontal divider. 00:03:46.200 --> 00:03:50.440 Now by scrolling the top and bottom sections, we can compare the data for any 00:03:50.440 --> 00:03:52.900 to sales people really easily. 00:03:52.900 --> 00:03:58.880 For example about David Carlson and...Melissa Post. 00:03:58.880 --> 00:04:02.360 Depending on your spreadsheet, some of these view options may be better than 00:04:02.360 --> 00:04:07.150 others. In this example, the header rows and columns are really important, so the 00:04:07.150 --> 00:04:11.700 Freeze Panes feature is probably our best choice. You'll want to try all the view 00:04:11.700 --> 00:04:15.620 options and see which one works best for your spreadsheet.