Please include the entire question in the body of the question.

To keep the first row(s) and column(s) visible as you scroll around
(freeze panes), or as you print (file setup) see
http://www.mvps.org/dmcritchie/excel/freeze.htm
and in help see
Keep row labels visible as you scroll
Print row labels on every page

If you want to refer to columns and rows by label names see HELP
About labels and names in formulas
Name cells in a workbook
By default, Microsoft Excel does not recognize labels in formulas.
To use labels in formulas, click Options on the Tools menu, and then
click the Calculation tab. Under Workbook options, select the Accept
labels in formulas check box

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"R9166" wrote in message ...
How do I do this???

Thanks