Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Freeze panes in excel 2010.

Show User Form By Clicking Data Custom Excel

Follow these steps to freeze panes in a worksheet.

Freeze panes excel 2010. In the window group of the view tab choose freeze panes freeze panes. Due to changes with how windows are containerized in excel 2013 and later you no longer protect windows in those versions when protecting a workbook. In the window group of the view tab choose freeze panes unfreeze panes to unlock.

Select view freeze panes freeze panes. Excel s freeze panes command also becomes disabled when the workbook is protected in excel 2010 and earlier as illustrated in figure 2. Position the cell cursor based on what you want to freeze.

Select the suitable option. To freeze more than one row or column or to freeze both rows and columns at the same time click freeze panes. Freeze rows or columns.

Excel 2010 freeze panes. When dealing with large amounts of data in an excel workbook you often need to use the freeze panes item on the ribbon. To freeze one row only click freeze top row.

To freeze one column only click freeze first column. Using freeze panes select the first row or first column or the row below which you want to freeze or column right to area which you want to freeze. Choose view tab freeze panes.

You can freeze rows columns or both rows and columns. This option allows you to keep a certain area visible as you scroll to other parts of your worksheet.