close

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.

Try wrapping the contents in the cell.

On the menu - Format --gt; Cells --gt; quot;Alignment Tabquot; --gt; Wrap Text

Try if this solves your problem.quot;Blueskyquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()