LinkBack URL
About LinkBacks
Is there any possibility to have excels workbooks on two screens (ex. laptop and monitor).
Thanks
Mario
Is there any possibility to have excels workbooks on two screens (ex. laptop and monitor).
Thanks
Mario
seeing as you can move windows around on 1 screen, the answer is yes, you can have 2 different workbooks open on 2 different screens...you just have to size them and movethem to where you want them to be
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, it's called mirrored (clone) mode and should be the default display option in a dual display environment. The other option is called extended display, where the screens complete each other. Search Google using the keywords and your version of windows and you should get simple instructions on how to accomplish this.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
If I move one workbook to another screen, all the other workbooks appear also on the same screen.
maroni,
With Excel open, go to your Windows Start menu, find Excel, and click on it, thereby opening a second instance of it, which you can move to your 2nd screen. (I often do it, and it's great)
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Thanks BB, you beat me to it, i was just about to say the same thing
BB,
this works, but I cannot link these two workbooks.
Are the screens connected to the same computer or to different ones? Your post indicated two different computers...
Ben Van Johnson
Yes, you are right. You can't. What you have to do is stretch you one instance of Excel across both screens then View >> View Side by Side. It may take a little tweaking since the resolution on both monitors might not be the same. This way you will see the ribbon stretched across both screens but different workbooks on each display.
abousetta
Expand the window to fill both monitors. Then you can open both workbooks and do side-by-side display.
Same computer...
maroni, if you follow abousetta or handerson's instructions above (posts 9 & 10) you should be able to achieve your goal.
LOL! We could still write that book, you know!Originally Posted by FDibbins
Thanks BB, you beat me to it, i was just about to say the same thing
Hi maroni
Have a look at the link below. I think Excel 2013 has ability to open 2 windows, might be wrong though.
http://answers.microsoft.com/en-us/S...question=False
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Thanks averyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks