ExcelBanter - Freezing cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Freezing cells (https://www.excelbanter.com/excel-worksheet-functions/106243-freezing-cells.html)

ksholars

Freezing cells

I am looking for a way to freeze a row so that it stays on the top of the
worksheet as I scroll down.

David Billigmeier

Freezing cells

Select the entire row directly below the row you want to freeze, then:

<Window
<Freeze Panes

--
Regards,
Dave

"ksholars" wrote:

I am looking for a way to freeze a row so that it stays on the top of the
worksheet as I scroll down.

jchen

Freezing cells

Try Freez Panes. It will all rows and columns that are above or left of the
current activecell.

"ksholars" wrote:

I am looking for a way to freeze a row so that it stays on the top of the
worksheet as I scroll down.

All times are GMT +1. The time now is 10:16 AM.