How do I lock cells from scrolling in Excel 2010?
How do I lock cells from scrolling in Excel 2010? In the Window group of the View tab, choose Freeze Panes→Freeze Panes. A thin black line separates the sections. As you scroll down and to the right, notice that the columns above and rows to the left of the cell cursor remain fixed. Keep titles visible by freezing the panes. How do I lock cells from scrolling in Excel? Freeze columns and rowsSelect the cell below the rows and to the right of the columns you want to keep visible when you scroll.Select View > Freeze Panes > Freeze Panes....