Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel TRANSPOSE Function
  • Perform case-sensitive Lookup in Excel
  • How to use Excel ROWS Function
  • How to get last column number in range in Excel
  • How to use Excel ROW Function

Data Analysis Examples

  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Randomize/ Shuffle List in Excel
  • Everything about Charts in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How To Create Frequency Distribution in Excel

Data Validation Examples

  • Excel Data validation allow weekday only
  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Prevent invalid data entering in specific cells
  • Excel Data validation no punctuation

Freeze and Unfreeze Panes in Excel

by

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

Freeze Top Row

To freeze the top row, execute the following steps.

1. On the View tab, in the Window group, click Freeze Panes.

2. Click Freeze Top Row.

Worked Example:   How to Consolidate(Merge) Records From Multiple Worksheets in Excel

3. Scroll down to the rest of the worksheet.

Result. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.

Note: to keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column.

Unfreeze Panes

To unlock all rows and columns, execute the following steps.

1. On the View tab, in the Window group, click Freeze Panes.

Worked Example:   Things you find in Excel Status Bar

2. Click Unfreeze Panes.

Freeze Panes

To freeze panes, execute the following steps.

1. Select row 3.

2. On the View tab, in the Window group, click Freeze Panes.

3. On the View tab, in the Window group, click Freeze Panes, Freeze Panes.

4. Scroll down to the rest of the worksheet.

Worked Example:   Protect and Unprotect Worksheet in Excel

Result. All rows above row 3 are frozen.

Note: to keep columns visible while scrolling to the right of the worksheet, select a column and click Freeze panes.

5. Select cell C3 (unfreeze panes first).

6. On the View tab, in the Window group, click Freeze Panes, Freeze Panes.

Result. The region above row 3 and to the left of column C is frozen.

Post navigation

Previous Post:

How to Create Area Chart in Excel

Next Post:

Conditional Formatting New Rule with Formulas in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove text by variable position in a cell in Excel
  • How to pad text to match equal length in Excel
  • EXACT function: Description, Usage, Syntax, Examples and Explanation
  • Remove file extension from filename in Excel
  • How to count total words in a cell in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate quarter from date in Excel
  • Get last weekday in month in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate future date say 6 months ahead in Excel
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles