Lock column/row in place

[pelachrum]

I'm on Excel 2004, Mac version.

I can't seam to figure out how to lock rows or columns so that when you
scroll the screen those columns/rows stay in place (like the top row for
column headings etc)

 

[Nick Hodge \(MVP\)]

Try (To lock top row and far left column, click in B2)

Window>freeze panes

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk