Excel advice please

  Enoch 11:03 28 Mar 2007
Locked

On Excel, there is a way of keeping the headings to each column showing on screen whilst filling up the cells below. Therefore when one passes the bottom of the visual screen with information in the cells, the headings remain on screen.

Being of senior years, I have forgotton how to do this, can anybody help please

  VoG II 11:05 28 Mar 2007

To keep row 1 displayed, click in A2 then Window > Freeze Panes.

To keep Column A and row 1 displayed click in B2 then Window > Freeze Panes.

  Enoch 11:16 28 Mar 2007

VoG-------You the Man!!!!!

Thank you

  conrail 09:12 14 May 2007

thanks VoG™, you have sorted out a problem for wife, a teacher

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Is this the future of VR and AR?

Best iPad buying guide 2017

Comment regarder le Bureau des Légendes en ligne ?