how to freeze multiple panes in excel 365

If you have privileges to freeze rows and columns then you should also be able to unfreeze them. Compare it with others for better understanding. The image shows how the result would function. Then navigate to Views -> Freeze Panes and click on Freeze Panes. Say for example, you want to render the first two rows and first two columns using this option, then you will have to select the cell counting the third row and third column. There is a little process to follow in order to make this work. This option is pretty interesting and it caters to needs of making multiple rows and columns non-scrollable. Again have a look the image below and compare with previous images. Choosing this option will always keep the first column intact. But when we do, it becomes important to acquire similar property for the entire column. Not always do we have headers for rows viz. Compare the image below with that shown at the top of the article take note of the scroll positions. This means that when you move the vertical bar downwards all but the top row will scroll with the scrolling bar. When you select this option the top row of your Excel sheet obtains the non-scrollable property. Navigate to View tab and highlight on Freeze Panes tool. MS Excel provides a diligent tool that lets you freeze the panes of your document such they do not scroll and remain on the viewable area at any time. Then what is the significance of headers if you cannot have them throughout? Well, you can and that’s what we are going to tell you today.īut before we move on let us have a look at my example set of data (left image) and how the headers hide out when I scroll my sheet (right image). If you notice closely you will see that the headers scroll away as you scroll the document (down or left). However, there is one flaw with doing just this much. Is that we (and the people we share our sheet with) may easily understand the data matrix and the data within it. We usually give a name to every column and sometimes, to rows too.

How to freeze multiple panes in excel 365