I can't unfreeze a row and freeze it somewhere else.

**craigu111** · 06-15-2009, 12:42 PM

I am working on a spreadsheet that i did not develop and the rows freeze at 24 and when I scroll the rows jump by muliples of 3 on each scroll. However the real problem is that I'm trying to freeze my column headers at row #1 and it won't allow me to unfreeze at the current location or freeze on row 1. Can someone please help?!
Thanks!!!
Craig

**shg** · 06-15-2009, 12:45 PM

Welcome to the forum.

If by scrolling you mean the scroll wheel on your mouse, that's set in mouse properties.

Sound like the workbook is protected -- unprotect it.

**craigu111** · 06-15-2009, 01:18 PM

Thanks...I don't know who protected it so...what are my other options?

**shg** · 06-15-2009, 01:36 PM

Tools > Protection > Unprotect workbook -- does that work?

**craigu111** · 06-15-2009, 01:47 PM

Unprotect workbook isn't an option.

**Paul** · 06-15-2009, 02:01 PM

Craig, how about posting a copy of the workbook so we can get this sorted out without too much guessing?

**craigu111** · 06-15-2009, 02:15 PM

Sure...here it is...thanks!!!

**Paul** · 06-15-2009, 02:34 PM

Craig, when I open your workbook there are no frozen panes, no protection, no scrolling issues, etc. It's just three sheets (only one with data in it - Closing Schedule), and I can scroll just fine. I can create a new frozen pane (for example, selecting cell C2 and freezing the panes), and remove it at will.

As for scrolling 3 rows at a time, that is a mouse property that you can change in the Windows control panel.

**craigu111** · 06-15-2009, 02:55 PM

WOW! You're right...thanks for all the help and I feel like I sort of wasted your time as I was going about freezing the panes all wrong.
Anyway...I REALLY APPRECIATE IT!!!