I would like to set it so multiple windows will be opened automatically every time I open that worksheet.

It should remember the locations of the windows, which area the windows show, zoom levels etc.

How could I achieve this? Do I need to resort to macro? Thank you.

  • Isn't this behavior is by default? – Lee Oct 2 '18 at 9:26
  • @Lee The behavior is strange. Sometimes it wont work. It appears if I completely close Excel and reopen Excel, and then open that worksheet, or if I restart the computer, it won't open multiple windows. Also some settings are not remembered, for example the size of each window. – masterton Oct 3 '18 at 6:50
  • It happened again just now. It is able to open multiple windows the first time I re-open the workbook (while keeping Excel opened). However it opens one window only the second time. It is weird. – masterton Oct 3 '18 at 7:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.