Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I freeze a pane on Excel but leave one line unfrozen?
I have frozen a pane on my SS to show my categories against data as you
scroll along, but my title ( on Row 1) disappears. I was wondering if there is a way of unfreezing the pane just for Row 1? Or making it so the title is constantly present |
#2
|
|||
|
|||
How do I freeze a pane on Excel but leave one line unfrozen?
Paul, select a cell in row 2 and then 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 "Paul S" <Paul wrote in message ... I have frozen a pane on my SS to show my categories against data as you scroll along, but my title ( on Row 1) disappears. I was wondering if there is a way of unfreezing the pane just for Row 1? Or making it so the title is constantly present |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I freeze a pane on Excel but leave one line unfrozen?
Paul
Freezing row 1 only prevents it from scrolling as you move down, not across. The only way to freeze say, A1:F1 would be to select G2 and freeze panes. This would also freeze columns A:F Perhaps experiment with windownew window then windowarrange. Gord Dibben Excel MVP On Tue, 15 Nov 2005 01:26:05 -0800, Paul S <Paul wrote: I have frozen a pane on my SS to show my categories against data as you scroll along, but my title ( on Row 1) disappears. I was wondering if there is a way of unfreezing the pane just for Row 1? Or making it so the title is constantly present |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Clicking on restore window button changing the freeze pane in exce | Excel Discussion (Misc queries) | |||
How do I subtract line k from line L in excel? | Excel Discussion (Misc queries) | |||
Validation above the Freeze Line | Excel Discussion (Misc queries) | |||
Freeze pane line | Excel Discussion (Misc queries) |