Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the row for title to be fixed during scrolling?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the row for title to be fixed during scrolling?
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 & 2003 "Eric" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the row for title to be fixed during scrolling?
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 "Paul B" wrote: 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 & 2003 "Eric" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the row for title to be fixed during scrolling?
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 & 2003 "Eric" wrote in message ... 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 "Paul B" wrote: 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 & 2003 "Eric" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the row for title to be fixed during scrolling?
Thank you very much
Eric "Paul B" wrote: 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 & 2003 "Eric" wrote in message ... 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 "Paul B" wrote: 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 & 2003 "Eric" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the row for title to be fixed during scrolling?
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 & 2003 "Eric" wrote in message ... Thank you very much Eric "Paul B" wrote: 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 & 2003 "Eric" wrote in message ... 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 "Paul B" wrote: 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 & 2003 "Eric" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set the row for title to be fixed during scrolling? | Excel Discussion (Misc queries) | |||
drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
fixed string length,even other record is copied | Excel Discussion (Misc queries) | |||
Export file to CSV delimited with fixed field length | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions |