From the course: Excel: You Can Do This
Unlock this course with a free trial
Join today to access over 23,100 courses taught by industry experts.
Freeze panes: See your data while scrolling - Microsoft Excel Tutorial
From the course: Excel: You Can Do This
Freeze panes: See your data while scrolling
(upbeat music) - A lot of times, we have to add data to a long list. We're scrolling all over the place and our headers go away. We don't know what the heck is going on. Check this data out. We've got names, people's favorite colors, their director, the manager, and then we scroll down and we have more data to enter, like Carlton Salazar, okay. What was in column F? We've got to scroll back up to see. When you've got a long list like this, no, stop. We're going to end this pain by freezing panes. The idea is we want to keep our headers, so we need to put our cursor where we want the scroll to happen. So I want to put my cursor on Monday because everything from row six and above, that's what we need to always see. In the view tab in Excel, we go to freeze panes, and freeze panes again. And now, see? The horizontal and the vertical lines showing where the scroll is going to happen. Watch. Now let's go back to Carlton Salazar. We know what column to put his favorite color, which is dark…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
Flash Fill: Merge data in different cells1m 51s
-
Linking sheets3m 3s
-
(Locked)
Copying, coloring, and naming tabs3m 3s
-
(Locked)
SUM: Calculating a basic sum2m 12s
-
(Locked)
Freeze panes: See your data while scrolling1m 57s
-
(Locked)
Conditional formatting2m 28s
-
(Locked)
Data validation: Ensure users don't input crazy data2m 23s
-
(Locked)
Create a drop-down list3m 27s
-
(Locked)
Create basic charts from scratch1m 38s
-
(Locked)
Split text in Power Query: Split real-world data fields2m 53s
-
(Locked)
IF statement2m 4s
-
(Locked)
COUNTIFS: Count entries based on conditions1m 40s
-
(Locked)
The #N/A error: What does it mean and what causes it?1m 45s
-
(Locked)
VLOOKUP4m 18s
-