close

I have 7 columns with different titles, when I scroll down the page how do I
keep the titles on top of each column so you can see what you are looking at.Hi

Select the first cell under your headings, in column A. Go to Window/Freeze
Panes.

Andy.

quot;Tommyquot; gt; wrote in message
...
gt;I have 7 columns with different titles, when I scroll down the page how do
gt;I
gt; keep the titles on top of each column so you can see what you are looking
gt; at.
gt;
quot;Tommyquot; gt; wrote in message
...
gt;I have 7 columns with different titles, when I scroll down the page how do
gt;I
gt; keep the titles on top of each column so you can see what you are looking
gt; at.

Select the row below your titles, Window menu, Freeze panes.
You can do the same with rows, columns, or both, just select the top
left-hand cell of the scrolling region before you freeze panes.
--
David Biddulph
I know how to freeze but I need to scroll both the top and bottom
window. Is there a way to change the name on the column tabs A, B, C
to Jan. Feb,Mar etc.? ed

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

    software

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