If you are talking about freezing the top row(s) for display
showing only some cells on the row,
Or repeating rows or columns for printing then the answer is
that you can't.
http://www.mvps.org/dmcritchie/excel/freeze.htm
If for printing you could change the color of the font for the
other cells so they don't show.
If you want something like a dictionary reference, or a telephone
book reference showing to first entry on the page and the last
entry on a page like kel-mcr then you would have to
essentially print each page in Excel separately and modify the
the header ech time you restart the printer to print a single page.
Another way would be to create another worksheet forcing in
your own page separators and extracting the information from
cells and placing them into inserted lines to carry the information.
If you are trying to print a cell larger than the other cells in a row
that is not possible, you could overlay some cells with a text box.
