Monday, 3 February 2020

microsoft excel - How to keep part of a spreadsheet always visible during navigation


I want to apologize in advance for asking something that's clearly available on the web. Unfortunately, I don't know the appropriate terminology though.


I'm looking to keep certain rows/columns always shown in excel. For example, in a worksheet with a lot of columns, I always want to see the name that exists on the far left. More importantly, how do I turn this off?



Answer



Use the Freeze Pane function, as illustrated here.



Excel has a nice feature called Freeze Panes that can solve such a problem. This feature allows you to keep information from scrolling off the screen when moving through a spreadsheet. As a matter of habit, I always freeze the second row.



To freeze columns and rows in Excel,



  1. From the View menu, verify you're using Normal.

  2. Click the row number just below the area you'd like to freeze. The whole row should highlight.

  3. Click the cell on that highlighted row to the right of the columns you would like to freeze.

  4. From the Window menu, select Freeze Panes.



You can also Unfreeze Panes using the dropdown box on the Freeze Panes button.


No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...