ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Table headers to remain on top (https://www.excelbanter.com/excel-discussion-misc-queries/181884-table-headers-remain-top.html)

EllenM

Table headers to remain on top
 
Hello,
I have a table with headers in the first two rows. How can I scroll through
my table and "lock" the first two rows remain on top?

Thanks,
Ellen

JLatham

Table headers to remain on top
 
Click/select cell A3 and then use Window | Freeze from the menu toolbar.

"EllenM" wrote:

Hello,
I have a table with headers in the first two rows. How can I scroll through
my table and "lock" the first two rows remain on top?

Thanks,
Ellen


FSt1

Table headers to remain on top
 
hi
place your curser at cell A3.
on the menu bar....
WindowFreeze panes.

regards
FSt1

"EllenM" wrote:

Hello,
I have a table with headers in the first two rows. How can I scroll through
my table and "lock" the first two rows remain on top?

Thanks,
Ellen


Niek Otten

Table headers to remain on top
 
Hi Ellen,

Select row 3. WindowFreeze Panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"EllenM" wrote in message ...
| Hello,
| I have a table with headers in the first two rows. How can I scroll through
| my table and "lock" the first two rows remain on top?
|
| Thanks,
| Ellen



EllenM

Table headers to remain on top
 
Thanks!!! So easy when you know how to do it.


All times are GMT +1. The time now is 11:03 PM.

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