Viewing Thread:
"Excel query"

http://www.adslguide.org.uk/files/ (SPACE) adslguide_product_info.xls

Does anybody know how to get the first 4 cells to remain in place when you scroll the rest of the file, like is shown with this Excel spreadsheet?

Thanks.

... it always is :o)

Told you it'll be easy when you know how !

Cool, thanks for that :o).

Yep, easy, goto cell C3 and then from the menu select Window and then Freeze Panes and the bars will appear :D

As with all Excel queries it is something really simple, I can't remember off the top of my head, have you tried Excel help with keywords like "fix cells"
Will ask someone at work tomorrow.

Sorry couldn't help.

http://www.adslguide.org.uk/files/ (SPACE) adslguide_product_info.xls

Does anybody know how to get the first 4 cells to remain in place when you scroll the rest of the file, like is shown with this Excel spreadsheet?

Thanks.