Excell arrange All - how to have single header for all excell windows

New Contributor

I did not upgrade for new version of excel due to this reason. But recently some bugs occurred in Excel 2007 so I need to upgrade. My pain every time I used in with multiple windows the header in each window retain unlike to old one it displays only 1 header. please help i m so tried of it already.






3 Replies
best response confirmed by Hans Vogelaar (MVP)


That's by design. Such so called Single Document Interface was introduced with Excel 2013, there is no way to switch it on older one (MDI).

@Sergei Baklan so sad as an accountant is very inconvenient.
I think there were two big reasons for the change to SDI: 1) users reporting sheets going 'missing' and 2) the case of 'vanishing' sheet tabs.