These options are visible on the view tab in the Freeze Panes menu. This makes it hard to understand the worksheet because we aren't able to see the columns and headers that give the data meaning.Įxcel provides three options for freezing columns and rows so that they don't scroll off the screen as you move through large sets of data. Notice that as we scroll down through the data, the headers scroll off the screen.Īnd, if we scroll to the right, the company name is no longer visible. Here we have a large data table with a header row at the top. In this lesson we'll look at how to do that. When you're working with a big list, it's often handy to freeze headers or columns so that they're always visible as you scroll through the data.
