Problem with Gridlines and Windows Pane Freeze

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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

Similar Threads

Freeze Panes? 1
Gridlines not printing?! 7
Gridlines won't show up in excel 2007 6
Freeze Pane Macro 1
Gridlines 3
Excel Freeze panes in Excel 3
Freeze Panes Question 1
Keep options permanent fora given workbook 5

Back
Top