any excel experts

chilli_dog

I've just been email an excel document from work, they have somehow managed to put the titles in line 1 and even when you scroll down to linee 300, line 1 titles are still in view,

Anyone no how you do this?

Would help me out loads at work.

Thanks
Martin

HoofeHearted

Highlight the row beneath the Column Headings and then select Window -> Freeze Panes. (If I understand your question correctly)

Sagz_2

hmmmm not 100% sure what you mean but you could try clicking 'Window' on the toolbar, then 'Unfreeze pane'

Of thats no help then please try and give a few more details and I'll have another go!

ben1234

Its simple, you simply highlight the row underneath the one that you want frozen (ie row 2 if you want the top to stay) and click Window - Freeze Panes. Hope this helps

real1314

Hoofehearted is right here, but I think it might actually be "unfreeze panes" you'll need to click on.

chilli_dog

Your all amazing, drinks all around, Beer for the lads & a small white wine for the ladies