SOLVED

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

Copper 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.

 

 

euj_ko_1-1679376967981.png

 

 

3 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@euj_ko 

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).

@SergeiBaklan 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.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@euj_ko 

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).

View solution in original post