1 00:00:00,210 --> 00:00:06,230 Let's take a look at how we can make it easier for us to navigate worksheets that have a lot of data. 2 00:00:06,240 --> 00:00:06,650 Imagine, 3 00:00:06,660 --> 00:00:12,420 I received this from my colleague and I'm scrolling down here and I want to take a look at this app 4 00:00:12,480 --> 00:00:13,710 and this number. 5 00:00:13,830 --> 00:00:14,920 I've lost the header. 6 00:00:14,940 --> 00:00:16,379 I don't know which month this belongs to. 7 00:00:16,379 --> 00:00:20,780 I have to scroll back up to see that it belongs to December 2019. 8 00:00:20,790 --> 00:00:22,350 I have the same problem 9 00:00:22,350 --> 00:00:25,600 If I have a lot of columns, so let's go all the way here. 10 00:00:25,650 --> 00:00:28,020 I've lost the labels, the apps. 11 00:00:28,140 --> 00:00:34,800 So for me to see what this number is associated with I not only have to scroll up to see the month but 12 00:00:34,800 --> 00:00:41,250 I also have to scroll back to the left to see which app this belongs to which can get quite frustrating. 13 00:00:41,250 --> 00:00:42,600 There are two ways around this. 14 00:00:42,600 --> 00:00:44,330 One is to use Freeze Panes. 15 00:00:44,340 --> 00:00:47,460 The other one is to use split screen. To Freeze Panes, 16 00:00:47,460 --> 00:00:53,630 you just have to click on the intersection of the row and column that you want to freeze. 17 00:00:53,640 --> 00:01:03,200 So in this example I want to freeze this row, this column, go to View > Freeze Panes, and select Freeze Panes. 18 00:01:03,210 --> 00:01:07,890 This puts a line right above this cell and to the left of the cell. 19 00:01:07,890 --> 00:01:10,800 Now notice what happens when I scroll down. 20 00:01:10,920 --> 00:01:12,770 I still see the header. 21 00:01:12,810 --> 00:01:16,560 It's frozen. When I scroll to the right, 22 00:01:16,560 --> 00:01:18,190 I still see the column. 23 00:01:18,270 --> 00:01:25,950 So no I have no problem to know which number these belong to. To take this option away, to unfreeze 24 00:01:25,950 --> 00:01:30,420 panes just click on it and select unfreeze panes. 25 00:01:30,420 --> 00:01:32,980 Now you also have two other defaults there. 26 00:01:33,060 --> 00:01:36,740 You can freeze the top row or freeze the first column. 27 00:01:36,750 --> 00:01:39,690 So in this case freezing the first column also works. 28 00:01:39,690 --> 00:01:44,010 I can just freeze that and be able to move to the right. 29 00:01:44,130 --> 00:01:49,300 But if I don't freeze the row I lose the information on the top row. 30 00:01:49,390 --> 00:01:50,780 So to take it away 31 00:01:50,940 --> 00:01:52,380 Just unfreeze. 32 00:01:52,380 --> 00:01:54,770 Now let's take a look at splitting the screen. 33 00:01:54,780 --> 00:02:01,590 What happens if I click on this cell here so A8 and I'm going to split the screen. 34 00:02:01,590 --> 00:02:07,180 I get two separate screens and notice something happened on the side here. 35 00:02:07,200 --> 00:02:11,070 I get another scroll bar in addition to the one I had before. 36 00:02:11,550 --> 00:02:15,900 So this allows me to be in a different position 37 00:02:15,930 --> 00:02:19,030 on the second screen then on the first screen. 38 00:02:19,380 --> 00:02:27,080 So if I'm only interested in the few top apps and some apps that are on the bottom and I want to compare 39 00:02:27,090 --> 00:02:34,140 the top app to the bottom app I can split the screen. If I take the split screen away and I add a split 40 00:02:34,140 --> 00:02:35,280 screen right here. 41 00:02:35,430 --> 00:02:41,610 I get four scroll bars two on the bottom and two on the side here. 42 00:02:41,610 --> 00:02:47,610 I personally prefer to use Freeze Panes. If I really need to compare two numbers that are completely 43 00:02:47,610 --> 00:02:49,720 on different sides of the workbook 44 00:02:49,770 --> 00:02:51,430 I will use split screen. 45 00:02:51,450 --> 00:02:51,700 OK. 46 00:02:51,720 --> 00:02:56,370 So try both out and see which ones you're going to need in which situations. 47 00:02:56,370 --> 00:03:00,960 This is going to save you a lot of unneeded scrolling when you're comparing data.