ExcelBanter - format row top of screen

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - format row top of screen (https://www.excelbanter.com/excel-discussion-misc-queries/31090-format-row-top-screen.html)

Pmcm

format row top of screen

I have a spreadsheet with many lines and want to have row 2 remain on the
screen when I scroll down. I have completely forgotton how to do this. Please
help.

Bob Phillips

Select C1, menu WindowFreeze Panes

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Pmcm" wrote in message
...
I have a spreadsheet with many lines and want to have row 2 remain on the
screen when I scroll down. I have completely forgotton how to do this.
Please
help.

All times are GMT +1. The time now is 01:52 AM.