i just cant remember how to freeze a few rows on top so that when i scroll, they stay there....

any help?

thanks!

Select the cell that will be the upper left of what you want to see (i.e. C10), then

Windows > Freeze Panes

isnt there another way? Selecting the cells i want to freeze doesnt seem to have any effect, the sheet is simply split into four quadrants....

what am i doing wrong?

thanks!

If you hit Freeze pane, then you are doing it correctly. If you want only the rows at the top (and no columns on the left) frozen. Then click a cell in column A (say A10). Then the top 10 rows will be frozen. Check by scrolling down.

what if i want only the three first rows to freeze? i'm pretty sure there is another way, just cant put my finger on it.....

Then click in cell A4, and Windows > Freeze Pane

I think you've got your Windows Split. I have one of those too, but mine will cost $600 to fix; yours is as easy as goto Window-->Remove Split. You can freeze from there like Shades said.

Hope that helps,

Smitty

(Heya Shades - How you doing?)

thanks, got it to work.... just wasnt sure how to select the cells i wanted to freeze...


Cheers!