I have a large worksheet in Excel and I want to freeze certain rows or columns so they remain visible while scrolling. What is the process for freezing panes in Excel?
- Select 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.
open the excel workbook that you want to freeze panes on. click on the cell below and to the right of the rows and columns you want to freeze. lick on the view tab on the ribbon. click the freeze panes in the window. select freeze panes rom the dropdown menu. The rows and columns above and to the left of the active cell will be frozen in the place.
To freeze certain rows and columns follow these steps
Choose the cell that you wish to keep visible when you scroll below the rows and to the right of the columns.
To freeze panes, select View > Freeze Panes.
Select View > Freeze Panes > Freeze Panes, well this is the Process for freeze panes in Excel