Saving 2 windows

J

John Allen

I have a single spreadsheet with 2 windows open. The vertical split is 60/40.
When I open the file this split has not saved and I have a 50/50 split and
there is no synchronised scrolling between the 2 windows. If I click on
compare side by side with, the window reverts to 60/40 and synchronised
scrolling is effective. These settings are not saved, so on File Open, I need
to repeat this procedure.

Is there any way to save these settings or program an Auto Open macro to
present the 60/40 split with scrolling?
 
H

Harald Staff

Hi

Save the file. Then save the workspace (also in File menu). Open the
workspace later on and you have it.

This works also for arrangements of windows of multiple files.

HTH. Best wishes Harald
 
N

NickHK

Harald,
All this time, that's something that I've never noticed/used.
Yesterday was the benefits of Shift+Edit.

Something new everyday.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top