Freeze Pane versus Split Screen - excel 2010

[JSH720]

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 headings), to "double dip" and I shouldnt use it. Isnt it essentially just a different look and performs the same as a freeze pane as far as filtering?

I think that they are seeing the header row twice, one at the top of the screen and once in the body of the screen and think it is filtering the filter, but I don't know.

Has anybody else seen this issue or is it just a misunderstanding about how split screen works. Just wanted to check for my own knowledge.

Thanks.

 

[JLGWhiz]

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 headings), to "double dip" and I shouldnt use it. Isnt it essentially just a different look and performs the same as a freeze pane as far as filtering?

I think that they are seeing the header row twice, one at the top of the screen and once in the body of the screen and think it is filtering the filter, but I don't know.

Has anybody else seen this issue or is it just a misunderstanding about how split screen works. Just wanted to check for my own knowledge.

Thanks.

You could defy your boss and try it to see for yourself. Or you could follow instructrions and keep your job.
They have diffenent operating characteristics. With the split screen, you can make entries and changes in different parts of the worksheet and see the results in other parts that you would not normally be able to see. Freeze panes basically locks a specific set of rows and/or columns on top or left of the screen while the rest can be scrolled.

 

[JSH720]

LOL! No, I wasnt going to defy my boss, but after in putting the same data in a spreadsheet for between 7 - 10 times for 133 rows, I wanted to make sure that I wasnt just totally stupid regarding the matter. Especially, since this was blamed for the data loss. Not going to do anything about it except for how they tell me to do it, but nice to know that I wasnt going crazier than normal. Appears the data loss is due to using many users on shared spreadsheets, some server errors and some administrative rights that were changed globally. It was a very frustrating week, and I appreciate the info very much.