Lock column/row in place

P

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)
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Need Help with a VBA subroutine 0
How to fix a number of rows below the selected cells? 0
Sum to a mid point in a dynamic table 2
Images are pixelated when saving to PDF 0
Help Freezing Multiple Rows 3
Help freezing multiple top rows 2
Wrapping and Anchors 0

Top