Tech Helproom
It's free to register, to post a question or to start / join a discussion
Excel windows, side by side.
Likes # 0
Posted April 24, 2012 at 2:14PM
I am using Office XP,with Windows7, but if I have two Excel progams open, they are on top of each other. When I close one, they both close! How do I get them to sit side by side?
Likes # 0
Likes # 0
Posted April 25, 2012 at 8:38AM
Sorry Chronus, but these options aren't available in OfficeXP. -at least, I don't think that they are. I think that these refer to Office 2007 or 2010 Thanks for your help though.
Likes # 0
Posted April 25, 2012 at 9:05AM
In Office 2003, which I use, the only way (I think) of doing what you want to do is to open up Excel, choose the file you want to open, then open Excel again, and open the file you want to see side by side. Double clicking on a file in Explorer just causes that file to be opened as a new window in the copy of Excel that's running. You have to 'force' Windows to open two copies of Excel.
Likes # 0
Posted April 25, 2012 at 10:33AM
In Office Excel 2003 it is: Window -> Arrange
I think perhaps you have confused the views of Window (Window is the open workbook) with the program Excel, and you are closing the program Excel instead of closing the Window (workbook)
I believe Office XP excel is the same.
Likes # 0
Posted April 25, 2012 at 10:43AM
Ah - Lotvic's response has made me realise that what I was talking about was when you're in a dual screen environment, and you want one spreadsheet open on one screen and another open on another screen...
Likes # 0
Posted April 26, 2012 at 12:57PM
benson68
I have just read your post and like Ian in Northampton, I use Office 2003. There if you have two or more spreadsheets open, click on 'Window' at the top and then make sure you get the full drop down list. One of the options is 'Compare side by side with..' which gives you the option to choose which spreadsheets you want to compare.
Likes # 0
Posted April 26, 2012 at 3:04PM
Housten,
I don't have this option. All that I get on the Window drop down list is:-New window, Arrange, Hide, unhide (greyed out) split & Freeze.
Iotvic,
Under arrange, there is only Tiled, Horizontal, Vertical, Cascade, Active & Windows of Active Workbook
Likes # 0
Posted April 26, 2012 at 8:51PM
Do this to view different worksheets in the same Workbook: Open your workbook in Excel > click on 'Window' to get the dropdown menu, > click on 'New Window', you now have the same workbook open twice
again click on 'Window', to get the dropdown menu > click on 'Arrange' > choose 'Vertical' and click on 'OK'. You can now look at two different worksheets from the same workbook (click on the sheet tabs at bottom). Each view will work independent of the other when you scroll up and down the worksheet. You can close one instance of the Workbook and the other will still be open and displayed.
Do this to view different Workbooks: Open Workbook1. > Open Workbook2. > click on 'Window', to get the dropdown menu > click on 'Arrange' > choose 'Vertical' and click on 'OK'. You can now look at two different Workbooks and if you close Workbook1. then Workbook2. will still be open and displayed.
If you choose 'Compare side by side' when you scroll your mouse button both of the Worksheets on view will move up and down together - not independently.
Likes # 0
Posted April 27, 2012 at 12:02PM
Iotvic
That's done it! Third paragraph. Isn't side by side, but it'll do. Thanks very much.
Likes # 0
Posted April 28, 2012 at 12:29PM
benson68,
I saw your reply to me, and I don't know why you don't have 'Compare', but I have usually 4 or 5 spreadsheets open, so I clicked on arrange and they all appeared on the screen!! If you are happy - especially as it works for you - stay with lotvic's advice, but I think it might be of help to you.
Best of luck with everything.
Reply to this topic
This thread has been locked.
Check out PC Advisor's other tech forums
Top 5 Most Popular
