Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel table

Sep 2, 2005 10:37AM PDT

Hello,

I am going to make a long table using excel.

I wonder if there is a way to do like:

the table is LONG, like 500 rows. the first row will NOT move even if I roll down the page.
such as: the first row say: name, item number, phone number, relationship, etc, and below second line is the data, I would like to know i can continue going down the table, but i can still see the first raw in order to track which column is what.

regards,
P

Discussion is locked

- Collapse -
(NT) (NT) Sure. Select row 2, and then Window>Freeze Panes
Sep 2, 2005 11:36AM PDT
- Collapse -
sweet
Sep 2, 2005 2:35PM PDT

Hello,

Thank you so much for the help!

Best regards
P

- Collapse -
I usually make the first row bold, to see the difference.
Sep 2, 2005 11:19PM PDT

But the columns can become broader then.