Click "Freeze Panes" to see your options.

Your options are:

1. Freeze Panes
2. Freeze top row
3. Freeze first column

Click "Freeze Top Row" to always show row 1.

Click "Freeze First Column" to always show column A.

To set which rows will freeze, highlight the row below which rows you want to freeze. In this example, by highlighting row 3, it will freeze rows 1 and 2.

You can now see which rows and columns are frozen based on the thicker lines.

Office

office.com

This guide provides a clear and concise step-by-step process for freezing panes in Microsoft Excel. It explains how to freeze the top row, first column, or specific rows, allowing users to easily keep important information visible while scrolling through large spreadsheets. Following this guide will help improve efficiency and organization when working with Excel.

How to Freeze Panes in Microsoft Excel