If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 monitors
I am running 2 monitors from my graphics card.
Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have tried drag and drop to no avail. Thank you. |
#2
|
|||
|
|||
2 monitors
Thanks Mr Tom!
It would be helpful to me if you could explain using different workbooks. Many thanks for taking the time and trouble. StuBela "mr tom" wrote: I've used 2 screens for years - with Excel it's an absolute boon. I'm sure you've worked out how to do this with different workbooks - if not reply, and I'll take you through that. To answer your question - no, I don't think it can be done for different sheets inside the same workbook. There is however a workaround - simply copy one of the sheets into a new workbook (keeping all links etc) and span the workbooks rather than the sheets. Again, if that needs further explanation, let me know. Sorry I've not got a more appealing answer! "StuBela" wrote: I am running 2 monitors from my graphics card. Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have tried drag and drop to no avail. Thank you. |
#3
|
|||
|
|||
2 monitors
I've used 2 screens for years - with Excel it's an absolute boon.
I'm sure you've worked out how to do this with different workbooks - if not reply, and I'll take you through that. To answer your question - no, I don't think it can be done for different sheets inside the same workbook. There is however a workaround - simply copy one of the sheets into a new workbook (keeping all links etc) and span the workbooks rather than the sheets. Again, if that needs further explanation, let me know. Sorry I've not got a more appealing answer! "StuBela" wrote: I am running 2 monitors from my graphics card. Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have tried drag and drop to no avail. Thank you. |
#4
|
|||
|
|||
2 monitors
Cool.
2 methods (I prefer the second) 1 Open 2 instances of Excel, each maximised in a different screen. This is less flexible as these instances will not "see" each other. 2 Open only one instance and span it across both screens (likely to need to "restore" rather than "maximise" and then manually resize (strech) it to size). Then, open a couple of workbooks, click the "Window" menu and tile them. You can then resize and move the different windows around. I've just noticed something. You actually can have different windows of one workbook. (I.e. you can do exactly what you want to do). To do this: Open your workbook. Span excel across both screens Click Window, New Window Click Window, Arrange, Tile You now have two windows of the same sheet which you can browse and resize as much as you want. Hopefully this'll do the job. Reply if any difficulties. "StuBela" wrote: Thanks Mr Tom! It would be helpful to me if you could explain using different workbooks. Many thanks for taking the time and trouble. StuBela "mr tom" wrote: I've used 2 screens for years - with Excel it's an absolute boon. I'm sure you've worked out how to do this with different workbooks - if not reply, and I'll take you through that. To answer your question - no, I don't think it can be done for different sheets inside the same workbook. There is however a workaround - simply copy one of the sheets into a new workbook (keeping all links etc) and span the workbooks rather than the sheets. Again, if that needs further explanation, let me know. Sorry I've not got a more appealing answer! "StuBela" wrote: I am running 2 monitors from my graphics card. Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have tried drag and drop to no avail. Thank you. |
#5
|
|||
|
|||
2 monitors
To display 2 sheets in the same work book click on windownew window and then
windowarrangetiled. Not sure how you put this onto your second monitor as I have never used 2 monitors. Hope that is of help -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "StuBela" wrote: I am running 2 monitors from my graphics card. Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have tried drag and drop to no avail. Thank you. |
#6
|
|||
|
|||
2 monitors
Wow oh wow!!!
JUST WHAT I NEEDED!!!! Thank you mr tom! "mr tom" wrote: Cool. 2 methods (I prefer the second) 1 Open 2 instances of Excel, each maximised in a different screen. This is less flexible as these instances will not "see" each other. 2 Open only one instance and span it across both screens (likely to need to "restore" rather than "maximise" and then manually resize (strech) it to size). Then, open a couple of workbooks, click the "Window" menu and tile them. You can then resize and move the different windows around. I've just noticed something. You actually can have different windows of one workbook. (I.e. you can do exactly what you want to do). To do this: Open your workbook. Span excel across both screens Click Window, New Window Click Window, Arrange, Tile You now have two windows of the same sheet which you can browse and resize as much as you want. Hopefully this'll do the job. Reply if any difficulties. "StuBela" wrote: Thanks Mr Tom! It would be helpful to me if you could explain using different workbooks. Many thanks for taking the time and trouble. StuBela "mr tom" wrote: I've used 2 screens for years - with Excel it's an absolute boon. I'm sure you've worked out how to do this with different workbooks - if not reply, and I'll take you through that. To answer your question - no, I don't think it can be done for different sheets inside the same workbook. There is however a workaround - simply copy one of the sheets into a new workbook (keeping all links etc) and span the workbooks rather than the sheets. Again, if that needs further explanation, let me know. Sorry I've not got a more appealing answer! "StuBela" wrote: I am running 2 monitors from my graphics card. Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have tried drag and drop to no avail. Thank you. |
Thread Tools | |
Display Modes | |
|
|