and if you want to do the same thing for display you would select B1 to freeze
left column only or B2 to freeze left column and top row, and then use
Window, freeze panes.
Freeze Panes for view and Repeat row/col headings for printing
http://www.mvps.org/dmcritchie/excel/freeze.htm