Excel Guru's..a quicky pls!!!

  spanneress 14:57 09 Aug 2004
Locked

Have been passed several huuuuuge spreadsheets in Excel...have totally forgotten how to lock the title row...tried freezing the panes but it froze columns 1-12...I just want to freeze row 1, columns A -J...please please save me from launching my best china at the door...aaarrgh!!

Thanks in advance.



(calm now)

  cga 15:02 09 Aug 2004

File- Page Setup - Sheet

I hope that ios what you want

  pj123 15:06 09 Aug 2004

Qickest I know is: just above the Up and Down scroll bars on the right hand side of screen is a very small grey button. Hold your mouse on it and you should get a doubleheaded arrow. Drag it down to below the title row and let go.

  spanneress 15:07 09 Aug 2004

Thanks!! But that is to repeat the titles when printing...as the spreadsheets are hhunders of lines long..I wish to be able to scroll down the page at will and still see the titles (so that I know what the cell should contain)...

  spanneress 15:08 09 Aug 2004

Cheers - my above reply was to cga not pj..will try now...if you hear crashing and cussing in an extremely unladylike fashion...it hasn't worked.

BRB

  VoG II 15:09 09 Aug 2004

Click in cell A2. Window/Freeze panes

  spanneress 15:10 09 Aug 2004

PJ you are a star, a gentleman and a vey nice bloke.

Ithangewe.

  spanneress 15:11 09 Aug 2004

PS..you too VoG.

What does it stand for by the way???

  cga 15:12 09 Aug 2004

Sorry -I misunderstood your question.

For the left/right lock the small grey button is to the right of the bottom scroll bar.

  spikeychris 15:12 09 Aug 2004

Very Old Git. And he is.

  spanneress 15:14 09 Aug 2004

OK...not to be too cheeky..but if I wanted to frees=ze row 1 (which I have) AND column A..how do I do this??

Use it or lose it..I taught Excel for years eons ago...sigh......

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?