Problem with Gridlines and Windows Pane Freeze

S

Shelly

I'm working on a workbook with many tabs. On all of these worksheets I've
set the "Freeze Panes" and unchecked the Gridlines box in Tools.

But, every so often these two settings get reset.... The gridlines reappear
and the Freeze Panes are removed from every worksheet!

It takes quite a bit of time to redo all of these.... any ideas why this
keeps happening?
 
D

Dave Peterson

Maybe you're hitting Window|New window?


I'm working on a workbook with many tabs. On all of these worksheets I've
set the "Freeze Panes" and unchecked the Gridlines box in Tools.

But, every so often these two settings get reset.... The gridlines reappear
and the Freeze Panes are removed from every worksheet!

It takes quite a bit of time to redo all of these.... any ideas why this
keeps happening?
 
S

Shelly

hmmmm, so if you want 2 windows of the same document (which I do frequently
to compare data) and you use the Window|New Windows menu item it will not
apply the same preferences you have set in the first windows? I didn't know
that..... very interesting.
 

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

Top