software

I would like to fix the row 1,2,3 for title, and when I scroll up / down,
then title is still there without affected by page up / down.
Does anyone know how to set the row for title to be fixed during scrolling?
Thank you
Eric

Eric, select A4 then window freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Ericquot; gt; wrote in message
...
gt; I would like to fix the row 1,2,3 for title, and when I scroll up / down,
gt; then title is still there without affected by page up / down.
gt; Does anyone know how to set the row for title to be fixed during
scrolling?
gt; Thank you
gt; Eric
Thank you for your suggestion
Will it be possible to freeze panes for row and column at the same time?
rather than freeze only for row or column
Thank you
Eric

quot;Paul Bquot; wrote:

gt; Eric, select A4 then window freeze panes
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Ericquot; gt; wrote in message
gt; ...
gt; gt; I would like to fix the row 1,2,3 for title, and when I scroll up / down,
gt; gt; then title is still there without affected by page up / down.
gt; gt; Does anyone know how to set the row for title to be fixed during
gt; scrolling?
gt; gt; Thank you
gt; gt; Eric
gt;
gt;
gt;

Eric, yes, just select a cell to the right of the column you want to freeze,
selecting B4 will keep rows 1:3 at the top and column A on the left.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Ericquot; gt; wrote in message
...
gt; Thank you for your suggestion
gt; Will it be possible to freeze panes for row and column at the same time?
gt; rather than freeze only for row or column
gt; Thank you
gt; Eric
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt; gt; Eric, select A4 then window freeze panes
gt; gt;
gt; gt; --
gt; gt; Paul B
gt; gt; Always backup your data before trying something new
gt; gt; Please post any response to the newsgroups so others can benefit from it
gt; gt; Feedback on answers is always appreciated!
gt; gt; Using Excel 2002 amp; 2003
gt; gt;
gt; gt; quot;Ericquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I would like to fix the row 1,2,3 for title, and when I scroll up /
down,
gt; gt; gt; then title is still there without affected by page up / down.
gt; gt; gt; Does anyone know how to set the row for title to be fixed during
gt; gt; scrolling?
gt; gt; gt; Thank you
gt; gt; gt; Eric
gt; gt;
gt; gt;
gt; gt;
Thank you very much
Eric

quot;Paul Bquot; wrote:

gt; Eric, yes, just select a cell to the right of the column you want to freeze,
gt; selecting B4 will keep rows 1:3 at the top and column A on the left.
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Ericquot; gt; wrote in message
gt; ...
gt; gt; Thank you for your suggestion
gt; gt; Will it be possible to freeze panes for row and column at the same time?
gt; gt; rather than freeze only for row or column
gt; gt; Thank you
gt; gt; Eric
gt; gt;
gt; gt; quot;Paul Bquot; wrote:
gt; gt;
gt; gt; gt; Eric, select A4 then window freeze panes
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Paul B
gt; gt; gt; Always backup your data before trying something new
gt; gt; gt; Please post any response to the newsgroups so others can benefit from it
gt; gt; gt; Feedback on answers is always appreciated!
gt; gt; gt; Using Excel 2002 amp; 2003
gt; gt; gt;
gt; gt; gt; quot;Ericquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I would like to fix the row 1,2,3 for title, and when I scroll up /
gt; down,
gt; gt; gt; gt; then title is still there without affected by page up / down.
gt; gt; gt; gt; Does anyone know how to set the row for title to be fixed during
gt; gt; gt; scrolling?
gt; gt; gt; gt; Thank you
gt; gt; gt; gt; Eric
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Ericquot; gt; wrote in message
...
gt; Thank you very much
gt; Eric
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt; gt; Eric, yes, just select a cell to the right of the column you want to
freeze,
gt; gt; selecting B4 will keep rows 1:3 at the top and column A on the left.
gt; gt;
gt; gt; --
gt; gt; Paul B
gt; gt; Always backup your data before trying something new
gt; gt; Please post any response to the newsgroups so others can benefit from it
gt; gt; Feedback on answers is always appreciated!
gt; gt; Using Excel 2002 amp; 2003
gt; gt;
gt; gt; quot;Ericquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Thank you for your suggestion
gt; gt; gt; Will it be possible to freeze panes for row and column at the same
time?
gt; gt; gt; rather than freeze only for row or column
gt; gt; gt; Thank you
gt; gt; gt; Eric
gt; gt; gt;
gt; gt; gt; quot;Paul Bquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Eric, select A4 then window freeze panes
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Paul B
gt; gt; gt; gt; Always backup your data before trying something new
gt; gt; gt; gt; Please post any response to the newsgroups so others can benefit
from it
gt; gt; gt; gt; Feedback on answers is always appreciated!
gt; gt; gt; gt; Using Excel 2002 amp; 2003
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ericquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; I would like to fix the row 1,2,3 for title, and when I scroll up
/
gt; gt; down,
gt; gt; gt; gt; gt; then title is still there without affected by page up / down.
gt; gt; gt; gt; gt; Does anyone know how to set the row for title to be fixed during
gt; gt; gt; gt; scrolling?
gt; gt; gt; gt; gt; Thank you
gt; gt; gt; gt; gt; Eric
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;