1 00:00:00,05 --> 00:00:02,05 - [Instructor] When you're working with a long Excel file, 2 00:00:02,05 --> 00:00:04,00 that takes a lot of scrolling, 3 00:00:04,00 --> 00:00:07,03 either downwards or across a bit. 4 00:00:07,03 --> 00:00:08,01 It can be helpful 5 00:00:08,01 --> 00:00:11,03 to lock in either the first or top header row of data, 6 00:00:11,03 --> 00:00:13,04 so that you can see what you're looking at. 7 00:00:13,04 --> 00:00:15,03 It's called freezing panes 8 00:00:15,03 --> 00:00:17,04 and you can do it in Excel. 9 00:00:17,04 --> 00:00:22,05 Change to the view tab and click freeze panes. 10 00:00:22,05 --> 00:00:26,00 Something that we can do is freeze the first column. 11 00:00:26,00 --> 00:00:29,01 What it's going to do is freeze column A, 12 00:00:29,01 --> 00:00:32,09 and now I can scroll horizontally through all of this data. 13 00:00:32,09 --> 00:00:36,05 I don't have to remember what category I'm looking at. 14 00:00:36,05 --> 00:00:37,07 To unfreeze it, 15 00:00:37,07 --> 00:00:39,04 come back here into freeze panes, 16 00:00:39,04 --> 00:00:41,00 which again is in the view tab, 17 00:00:41,00 --> 00:00:43,05 and click unfreeze panes. 18 00:00:43,05 --> 00:00:45,00 It's going to remove that line 19 00:00:45,00 --> 00:00:48,05 and now everything scrolls as normal. 20 00:00:48,05 --> 00:00:50,02 Something else that you might want to do 21 00:00:50,02 --> 00:00:53,00 is freeze just the top row. 22 00:00:53,00 --> 00:00:55,09 Many times, though not in this sheet in particular, 23 00:00:55,09 --> 00:00:58,02 the first row is all column headers. 24 00:00:58,02 --> 00:01:01,09 Things like first name, last name, dollar amounts, anything. 25 00:01:01,09 --> 00:01:03,06 If you're scrolling through a long list, 26 00:01:03,06 --> 00:01:06,02 you may forget what those values are. 27 00:01:06,02 --> 00:01:08,00 But if you freeze the top row, 28 00:01:08,00 --> 00:01:12,01 you'll still be able to see them while you're scrolling. 29 00:01:12,01 --> 00:01:14,01 But what about a sheet like this, 30 00:01:14,01 --> 00:01:16,03 which has a lengthy header file. 31 00:01:16,03 --> 00:01:17,07 It's got more then a few rows, 32 00:01:17,07 --> 00:01:19,01 and I want to make sure 33 00:01:19,01 --> 00:01:22,03 I can see these dates while I'm scrolling. 34 00:01:22,03 --> 00:01:24,09 What I can do is place the cursor, 35 00:01:24,09 --> 00:01:28,03 and it has to be on the left-hand side of the edge here 36 00:01:28,03 --> 00:01:31,00 where I want the columns to freeze. 37 00:01:31,00 --> 00:01:33,00 I'll go back to freeze panes, 38 00:01:33,00 --> 00:01:37,02 and this time I'll select the top option, freeze panes. 39 00:01:37,02 --> 00:01:39,09 This option is based on my selection. 40 00:01:39,09 --> 00:01:41,09 So now when I scroll, 41 00:01:41,09 --> 00:01:48,04 it's going to keep that whole header file intact. 42 00:01:48,04 --> 00:01:51,06 And again, I can come back into freeze panes, 43 00:01:51,06 --> 00:01:54,07 and this time it says unfreeze panes. 44 00:01:54,07 --> 00:01:58,01 So now it will scroll as normal. 45 00:01:58,01 --> 00:02:01,02 Something else that you can do with Excel is split the view 46 00:02:01,02 --> 00:02:05,04 and you can either split it vertically or horizontally. 47 00:02:05,04 --> 00:02:07,08 Let's suppose I want to look at this data here, 48 00:02:07,08 --> 00:02:09,03 the executives, 49 00:02:09,03 --> 00:02:10,07 but if I scroll down, 50 00:02:10,07 --> 00:02:13,00 I also want to look at some marketing data 51 00:02:13,00 --> 00:02:14,05 and data below that. 52 00:02:14,05 --> 00:02:16,09 But they're not near each other. 53 00:02:16,09 --> 00:02:19,09 I can do this by splitting the view. 54 00:02:19,09 --> 00:02:22,09 Splitting the view works similarly to marking the column 55 00:02:22,09 --> 00:02:25,01 in which it has to be on the left-hand side, 56 00:02:25,01 --> 00:02:27,03 that is, the edge of the screen. 57 00:02:27,03 --> 00:02:32,09 I'll place cursor on the cell that I want to split, 58 00:02:32,09 --> 00:02:34,07 and I'll click the split button, 59 00:02:34,07 --> 00:02:37,05 which is right next to the freeze button. 60 00:02:37,05 --> 00:02:39,08 Now it's hard to see this line here, 61 00:02:39,08 --> 00:02:42,02 but what I do see on the right-hand side 62 00:02:42,02 --> 00:02:45,00 is now there's two different sets of scroll bars. 63 00:02:45,00 --> 00:02:46,05 The screen is split, 64 00:02:46,05 --> 00:02:48,08 and I can look at this data here 65 00:02:48,08 --> 00:02:52,08 and I can look at this data here. 66 00:02:52,08 --> 00:02:54,06 I can look at them both at the same time, 67 00:02:54,06 --> 00:02:57,03 even though they were far away from each other on the sheet. 68 00:02:57,03 --> 00:03:00,06 In fact, if I wanted to I can hover my mouse 69 00:03:00,06 --> 00:03:03,00 over the line where I initiated the split, 70 00:03:03,00 --> 00:03:06,08 and drag it up. 71 00:03:06,08 --> 00:03:08,02 You'll see here on the right, 72 00:03:08,02 --> 00:03:12,00 I just split the scroll bar perfectly in half. 73 00:03:12,00 --> 00:03:14,08 To unsplit them, just click that split button again, 74 00:03:14,08 --> 00:03:17,03 and it puts your sheet back to normal. 75 00:03:17,03 --> 00:03:19,09 I can also do this with a column. 76 00:03:19,09 --> 00:03:23,02 This time, I'll select the entire column 77 00:03:23,02 --> 00:03:26,08 and click split again. 78 00:03:26,08 --> 00:03:30,00 And now, I have these horizontal bars. 79 00:03:30,00 --> 00:03:31,06 It's the same data. 80 00:03:31,06 --> 00:03:33,08 It's just showing it to me in two different panes 81 00:03:33,08 --> 00:03:36,03 so that I can see them at the same time. 82 00:03:36,03 --> 00:03:39,04 Maybe I want to see February near November. 83 00:03:39,04 --> 00:03:42,00 And again, I can click split again, 84 00:03:42,00 --> 00:03:44,00 which is from the view ribbon tab 85 00:03:44,00 --> 00:03:47,00 and it puts everything back to the way it was.