Column on left not repeating

[Midkiffc]

I have my top row repeating on each workbook screen. But I am not able to get the first column to repeat when I move my workbook over.

Under "Print Titles" I have Rows to repeat at top set as $1:$1 - this works. I have Columns to repeat at left set as $A:$A. This does not work when I am scrolling over.

FYI: I am not printing this workbook. Just want to see the column A as I scroll over.

Any assistance would be greatly appreciated.

 

[Norie]

Use Freeze Panes.

 

[Midkiffc]

Norie, thank you. I use Excel but am certainly NOT good at it.

 

[Midkiffc]

Use Freeze Panes.

Norie, I did this and now my top row isn't staying visible. Is this an either or? How do I freeze top row AND first column?

 

[Norie]

Put the cursor in B2 and then goto Freeze panes, that should freeze the top row and first column.