How can I keep the headers (names & description in the first 5 rows)
being row up when I scroll down the rows.

I mean to keep the 5 rows visible always.

Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

How can I keep the headers (names & description in the first 5 rows)
being row up when I scroll down the rows.

I mean to keep the 5 rows visible always.

Select row 6. Use menu Windows | Freeze Panes.

HTH,
Merjet

Thanks a lot for the tip, Merjet.

Regards.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Select cell A6 (the first cell you want to scroll)
Using menus, Windows -- Freeze Panes

If you wanted the first two columns to be frozen too
then you would select cell C6.

Chrissy


Michael168 wrote
How can I keep the headers (names & description in the first 5 rows)
being row up when I scroll down the rows.

I mean to keep the 5 rows visible always.