freeze panes issues

I've got some code that is intended to open up a second window (you know when you have the same workbook open on two separate screens? Super helpful... But, whenever it opens, in its attempt to maintain the freeze pane structure, it adds in some actual split panes.. just want to keep the...

Running Office Home and Student 2016 I have a spreadsheet in which months ago I locked (froze?) the top few rows so they'd stay visible as I scrolled down. Now I'd like to add some rows to that and I can find no way to do this. The Freeze Pane icon is grayed out. The workbook is NOT...

I hope there's an explanation for this. I'm setting a custom view that has certain sorts set on my data. I'm filtering by columns E and I. Once I've applied the custom view, I go to Data-> Sort & Filter-> Clear so that I can see all of my data again. When I do that, the data that was filtered...

okay, we migrated to 2010, which although has some nice features, has been a nightmare, primarily because we have to use shared excel files (about 5 people), but that is another post. I have been told that if I use a split screen instead of a freeze pane, it can cause the filters (used in the...