Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Dual Monitors - A trick that works
When I need to work in two separate Excel files on two separate monitors,
here's something I do: StartRunExcel. Take that instance of Excel and drag it to one monitor (downsize it first). Again, click StartRunExcel; this will open a new instance of Excel. Open your Excel files. You can now work in two separate files. Remember: when working with dual monitors, you cannot copy/paste a formula from one file to another. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Dual Monitors - A trick that works
You can do it in one instance of excel:
Open both workbooks, resize EXCEL (the app, not the file) and widen it so it spans both monitors, then use Window/Arrange/Tiled and each will be on a separate monitor. Now you CAN copy/paste formulas! I do it all the time! Bob Umlas Excel MVP "Helen" wrote in message ... When I need to work in two separate Excel files on two separate monitors, here's something I do: StartRunExcel. Take that instance of Excel and drag it to one monitor (downsize it first). Again, click StartRunExcel; this will open a new instance of Excel. Open your Excel files. You can now work in two separate files. Remember: when working with dual monitors, you cannot copy/paste a formula from one file to another. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Dual Monitors - A trick that works
I don't use multiple monitors, but it's not the multiple monitors that causes
the problem with copying and pasting formulas--it's that you have two workbooks open in separate instances of excel. You may want to try resizing your windows so that you have multiple workbooks in one instance across two (or more) monitors. Chip Pearson explains it with pictures: http://cpearson.com/excel/MultipleMonitors.aspx Helen wrote: When I need to work in two separate Excel files on two separate monitors, here's something I do: StartRunExcel. Take that instance of Excel and drag it to one monitor (downsize it first). Again, click StartRunExcel; this will open a new instance of Excel. Open your Excel files. You can now work in two separate files. Remember: when working with dual monitors, you cannot copy/paste a formula from one file to another. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Dual Monitors - A trick that works
If you need to copy a formula from one book to another, just copy and paste
the text portion of the formula, without the equal sign, and then re-insert the equal sign in the new book........... Vaya con Dios, Chuck, CABGx3 "Helen" wrote: When I need to work in two separate Excel files on two separate monitors, here's something I do: StartRunExcel. Take that instance of Excel and drag it to one monitor (downsize it first). Again, click StartRunExcel; this will open a new instance of Excel. Open your Excel files. You can now work in two separate files. Remember: when working with dual monitors, you cannot copy/paste a formula from one file to another. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dual monitors | Excel Discussion (Misc queries) | |||
Excel - Dual Monitors - 1 Tab on each monitor | Excel Discussion (Misc queries) | |||
how do I use excel on dual monitors | Excel Discussion (Misc queries) | |||
Opening two excel worksheets with dual monitors. | Excel Worksheet Functions | |||
Dual monitors | Excel Discussion (Misc queries) |