Mark Rows for scrolling

D

Doug Mc

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
 
D

Dave Peterson

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.
 
D

Doug Mc

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top