Hopefully this will make sense.
In previous versions of Excel, when you do the side by side view, there was one formula bar and ribbon across the top workbook. If the bottom workbook was active and you clicked on the ribbon, it made the change to the bottom workbook.
With Office 365, each workbook now has it's own ribbon and formula bar. If the bottom workbook is active and you clicked on the ribbon, it makes the requested change to the top workbook. This is annoying for two reasons: A- I forget that it's independent and have to undo a lot (what can I say, old habits die hard); and 2- without the bottom ribbon present you could view more rows of each workbook. And yes, I tried hiding the bottom ribbon and that does give me more rows, but on the bottom workbook only. The top remains with fewer rows showing.
So I guess my question is- is this true? Has anyone else noticed this? And is there a way to make it go back to the old way, so that they share the top part of Excel and each show more rows?
Ok here are pics of the old way and the new way.