Excel Spreadsheets

[pokolbinguy]

Hi all,

I was hoping someone could let me in on something. When using excel how do you lock the movement of cells so that when you scroll through the page a certain row or column does not move.... alllowing you to read say column A when you are scrolled over to column Z??

Cheers, Pok

 

[InCider]

Hey Pok,

Go to 'window' and then 'freeze panes' on the menu bar. What cell you have highlighted determines where the window sits.

Doing MS Help out of a job

InCider.

 

[pokolbinguy]

Its ok... sorted

 

[pokolbinguy]

Hey Pok,

Go to 'window' and then 'freeze panes' on the menu bar. What cell you have highlighted determines where the window sits.

Doing MS Help out of a job

InCider.

I just worked it out using the help

 

[muted3]

freeze cells or look up help...sorry in a bad mood...need to vent my fustration on someone :lol: