ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to create frozen header row? (https://www.excelbanter.com/excel-discussion-misc-queries/142001-how-create-frozen-header-row.html)

david.karr

How to create frozen header row?
 
I'm trying to make my first row in my spreadsheet always be visible,
but only once. I tried to follow some of the tips I found on the
internet to do this, but this seems to make that row appear twice,
once in the frozen section, and one in the first row of the section
below it.


Niek Otten

How to create frozen header row?
 
Select cell A3, from the menu choose WindowFreeze panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"david.karr" wrote in message ups.com...
| I'm trying to make my first row in my spreadsheet always be visible,
| but only once. I tried to follow some of the tips I found on the
| internet to do this, but this seems to make that row appear twice,
| once in the frozen section, and one in the first row of the section
| below it.
|



david.karr

How to create frozen header row?
 
On May 8, 10:51 am, "Niek Otten" wrote:
Select cell A3, from the menu choose WindowFreeze panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"david.karr" wrote in oglegroups.com...

| I'm trying to make my first row in my spreadsheet always be visible,
| but only once. I tried to follow some of the tips I found on the
| internet to do this, but this seems to make that row appear twice,
| once in the frozen section, and one in the first row of the section
| below it.
|


Perfect. Thanks.



All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com