ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Freeze pane works in some workbooks but not others (https://www.excelbanter.com/excel-worksheet-functions/173296-freeze-pane-works-some-workbooks-but-not-others.html)

Dave

Freeze pane works in some workbooks but not others
 
Hello,
Soemthing is wrong with some of my workbooks. When freezing a row, it will
stay frozen until I change the view, then it moves.

I was told to try creating a new work book and pastin in my info. When I
try this the rows and colums don't match up the same size and my workbook is
a mess.

Something must be corrurpt in my workbook to make the freeze pane stop
working.
DAVE


CLR

Freeze pane works in some workbooks but not others
 
Does the FreezePanes feature fail to work the in all sheets in the workbook,
or just the one?

Maybe try right-click on the sheet tab, then select MoveOrCopy, check the
create copy box, select (move to end), OK.........this will make a complete
copy of your sheet within the same workbook..........check it to see if the
FreezePanes work there.

Vaya con Dios,
Chuck, CABGx3

"DAVE" wrote:

Hello,
Soemthing is wrong with some of my workbooks. When freezing a row, it will
stay frozen until I change the view, then it moves.

I was told to try creating a new work book and pastin in my info. When I
try this the rows and colums don't match up the same size and my workbook is
a mess.

Something must be corrurpt in my workbook to make the freeze pane stop
working.
DAVE



All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com