Try wrapping the contents in the cell.

On the menu - Format -- Cells -- "Alignment Tab" -- Wrap Text

Try if this solves your problem.


"Bluesky" wrote:

When i choose Columns to Repeat at Left A$:A$, it can repeat to other pages.
But the problem is that the information in cell A1(the col. header text for
the col.) is wider than the cell, so that in print preview when I go to the
next page, it doesn't display all the wording.(The First page can display all
words) Just wondering if there is a work-around solution or function to
enable me to display all the text without having to widen the col. Many
thanks.