Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Mark Rows for scrolling
This seems weird!
I mark row 4 and row 1 and click on Freeze Panes. Rows 1-3 become frozen. There's also a black line below Row 6 that acts like another Freeze (Rows 4-6!) Does anybody have an answer to this? Thanks, Doug |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Mark Rows for scrolling
I'm not sure what mark means here, but freeze panes will freeze rows above the
activecell and to the left of the activecell. So if you meant that you selected rows 1:4, then it would only matter what cell was the activecell. If that activecell is in row 4, then rows 1:3 would be frozen. (You can select a multicell range and tab through that selection to experiment.) And you may be seeing Window|Split. You only get one split/freeze panes per window. But that doesn't look black to me. It's more grayish--and thicker. Any chance that it's just a page break or a cell border???? But neither of these would behave like freeze panes. Doug Mc wrote: This seems weird! I mark row 4 and row 1 and click on Freeze Panes. Rows 1-3 become frozen. There's also a black line below Row 6 that acts like another Freeze (Rows 4-6!) Does anybody have an answer to this? Thanks, Doug -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Mark Rows for scrolling
Thanks Dave,
I'm just now getting around to reading your memo. I probably just set it up wrong. I may have clicked on the "number" on the extreme left of the sheet instead of an active cell. I'll give it another try tomorrow and let you know how I come out. Thanks again, Doug "Dave Peterson" wrote in message ... I'm not sure what mark means here, but freeze panes will freeze rows above the activecell and to the left of the activecell. So if you meant that you selected rows 1:4, then it would only matter what cell was the activecell. If that activecell is in row 4, then rows 1:3 would be frozen. (You can select a multicell range and tab through that selection to experiment.) And you may be seeing Window|Split. You only get one split/freeze panes per window. But that doesn't look black to me. It's more grayish--and thicker. Any chance that it's just a page break or a cell border???? But neither of these would behave like freeze panes. Doug Mc wrote: This seems weird! I mark row 4 and row 1 and click on Freeze Panes. Rows 1-3 become frozen. There's also a black line below Row 6 that acts like another Freeze (Rows 4-6!) Does anybody have an answer to this? Thanks, Doug -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fix the top-most 4 rows when scrolling? | Excel Discussion (Misc queries) | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
how do i mark range from A1 to DV5000 without scrolling? | Excel Discussion (Misc queries) | |||
excessive rows when scrolling down | Excel Worksheet Functions |