So basically the rule of thumb here is as follows. I have highlighted the applicable active cell that should be activated and after that it is a round trip to the View tab and the Freeze Panes button where you choose the Freeze Panes option. To clarify I have selected the first three columns and the top row again. I don’t want the first column frozen but I want the first three columns to freeze and the top row as well. Your first column and top row are now frozen! Click the little arrow and click Freeze Panes. So it is of to the View tab and the freeze panes button. Now Excel knows it needs to freeze the top row and the first column. In this case you should set the active cell to B1 (highlighted yellow in the picture below). To freeze the first row and the first column you have to position your cursor in the correct cel. It is the position of the active cell that is important here. You don’t have to select the first column and the top row to get things done. In the picture above I have selected the first row and the first column just for clarification. So what we are looking for is the top row frozen and the first column frozen. Sure you want both ways because that is what Excel users do, scroll right and down. Ok we are getting there! But here is the next challenge…. In that case choose the option Freeze First Column.
You can apply the same if you want to keep your first column visible. You can now scroll down and your header labels will stay visible as requested. Excel will automatically freeze the top row for you. Now from the View tab click the Freeze Panes button (arrow) and choose Freeze Top Row. Make sure you have placed your cursor somewhere in the list. Well in that case you can use the Freeze Pane functionality. We remove the format as table functionality and try to accomplish the same with Freeze Panes. Right out of the box functionality for you. If you don’t want to have the annoying filter arrows just remove the filter by clicking on the Data tab and the Filter button. Now try scrolling down and see what happens with your headers? Wow the column letters disappear and are replaced by your header labels. This will convert your list into a table. Click on the Home tab and click on the Format as Table button. By far the easiest one is to create a table out of your list. There are various options to choose from. So we want to keep the top row so when we scroll down the header labels will stay visible.Īs you know by default Excel will scroll down everything so you will not see your header labels anymore. In the picture below you see part of a list which has no formatting. Here is what we are trying to accomplish. In this blog post I will show you the use of Freeze Panes to keep you from losing the list headers. Far to often I see people struggling with this option while actually it is pretty straight forward to use.
This is where the Freeze Panes functionality steps in. That way you can’t tell what the column headers are when you are scrolling down. If you start scrolling down the default setting in Excel is to scroll the headers (labels) as well. When working with long lists in Microsoft Excel you will probably want to see the top row all the time so you can see the labels.
0 kommentar(er)
