Excel: How to See Headings as You Scroll Around a Report

Lock Excel Heading Rows in Place

Discover More. The question is about changing the column headers, not the first row of data. If you are simply changing what is displayed in the worksheet by using the vertical scroll bar, then the frozen headings won't change because you are not changing the selected cell and the event handlers never trigger. You can always ask an expert in the Excel Tech Community , get support in the Answers community , or suggest a new feature or improvement on Excel User Voice.

How to Keep Rows Stationary in Excel

I am facing a problem in attendance sheet, i need visible top row and left column while scrolling. Nadeesha says: Here is a link to the page.

Learn more. Otherwise you'll quickly notice one peculiarity - this option does exactly what it promises, it freezes the top visible row. Get new features first. As an example, if you only wanted the third through fifth rows visible, scroll down until the third row is the first visible row at the top of the screen.

microsoft excel - Freezing a header row until another header scrolls on screen - Super User

Related Here's how you make that happen:. When I filtered the data, the header name of each column in the worksheet its does not appear. The faint line that appears between Column A and B shows that the first column is frozen. Skip to content. Contact Support. In other words, you are pressing the Down Arrow key to do your scrolling.

To unfreeze the top row, choose Unfreeze Panes from the same menu.

Freeze panes to lock rows and columns - Excel

Hi, I want to have my first row to be in bold and centered for example. It'll look like this now: Then choose Freeze Panes from the menu. Your workbooks can contain many, many worksheets. How to freeze columns or rows in a list. Format an Excel table. Filter data in a range or table.