How to Freeze Panes in Excel 2010?

To freeze panes, you can keep specific rows or columns visible when you scroll in the worksheet. For example, you can view distant parts of the worksheet while the headings remain in place.

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

Follow these steps to freeze panes in a worksheet:

A. Select the cell cursor based on what you want to freeze:

  1. Columns: Select the column to the right of the columns you want to freeze. For example, click any cell in column B to freeze column A.
  2. Rows: Select the row below the rows you want to freeze. For example, click any cell in row 4 to freeze rows 1, 2, and 3.
  3. Columns and rows: Click the cell below the rows and to the right of the columns you want to freeze — essentially, the first cell that isn't frozen. For example, click cell B2 to freeze both column A and row 1.
Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

B. Go to the Ribbon, click the "View" tab >>> "Windows" group >>> "Freeze Panes".

excel-freeze-panes

C. Go to the Ribbon, click the "View" tab >>> "Windows" group >>> "Unfreeze Panes".

excel-unfreeze-panes


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh