How To Make Header Stay When Scrolling Excel. On your ipad, tap view > freeze panes > freeze panes. Select view > freeze panes > freeze panes.
How to Add a Header in Excel
As you scroll down in your worksheet, the top row remains visible regardless of how far. Select view > freeze panes > freeze panes. Web in the ribbon, select view > freeze panes. Secondly, go to the view tab. Web select the cell below the rows and to the right of the columns you want to keep visible when you scroll. On your ipad, tap view > freeze panes > freeze panes. Thirdly, choose the freeze panes. Select the row below the last row you want to freeze. Web using freeze panes option to keep row headings in excel when scrolling. Shift to the worksheet you need to make header row follow, select cell a2 (or the first cell under your header row), and then click view > freeze panes > freeze panes.
Web in the ribbon, select view > freeze panes. On your ipad, tap view > freeze panes > freeze panes. Secondly, go to the view tab. As you scroll down in your worksheet, the top row remains visible regardless of how far. Web select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Web using freeze panes option to keep row headings in excel when scrolling. Shift to the worksheet you need to make header row follow, select cell a2 (or the first cell under your header row), and then click view > freeze panes > freeze panes. Thirdly, choose the freeze panes. Web in the ribbon, select view > freeze panes. Select view > freeze panes > freeze panes. Select the row below the last row you want to freeze.
