Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
I would like to open two spereadsheets. I want to read one and edit the
other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
Hi
Open the two workbooks, then goto "Window" "Arrange" select vertical or horizontal Regards, Per On 29 Nov., 15:13, Tom59 wrote: I would like to open two spereadsheets. I want to read one and edit the other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
Thanks Per, this just splits the single window. I have two monitors and would
like to use one spreadsheet on one. I have had it working like that previously, but something has changed and I don't know what. "Per Jessen" wrote: Hi Open the two workbooks, then goto "Window" "Arrange" select vertical or horizontal Regards, Per On 29 Nov., 15:13, Tom59 wrote: I would like to open two spereadsheets. I want to read one and edit the other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
Look he
http://www.cpearson.com/excel/MultipleMonitors.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Tom59" wrote in message ... Thanks Per, this just splits the single window. I have two monitors and would like to use one spreadsheet on one. I have had it working like that previously, but something has changed and I don't know what. "Per Jessen" wrote: Hi Open the two workbooks, then goto "Window" "Arrange" select vertical or horizontal Regards, Per On 29 Nov., 15:13, Tom59 wrote: I would like to open two spereadsheets. I want to read one and edit the other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
To use Excel with multiple monitors (I use 4), first resize the Excel
application window from maximized to that it stretches across all monitors. Then, open the workbooks. Resize and position each workbook window so that it fills one monitor, one workbook window per monitor. You may want to turn off the multiple task bar items. Go to the Tools menu, choose Options, then the View tab. There, uncheck "Windows In Taskbar". Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 29 Nov 2008 07:55:00 -0800, Tom59 wrote: Thanks Per, this just splits the single window. I have two monitors and would like to use one spreadsheet on one. I have had it working like that previously, but something has changed and I don't know what. "Per Jessen" wrote: Hi Open the two workbooks, then goto "Window" "Arrange" select vertical or horizontal Regards, Per On 29 Nov., 15:13, Tom59 wrote: I would like to open two spereadsheets. I want to read one and edit the other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
Thank you both for that - Tom.
"Chip Pearson" wrote: To use Excel with multiple monitors (I use 4), first resize the Excel application window from maximized to that it stretches across all monitors. Then, open the workbooks. Resize and position each workbook window so that it fills one monitor, one workbook window per monitor. You may want to turn off the multiple task bar items. Go to the Tools menu, choose Options, then the View tab. There, uncheck "Windows In Taskbar". Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 29 Nov 2008 07:55:00 -0800, Tom59 wrote: Thanks Per, this just splits the single window. I have two monitors and would like to use one spreadsheet on one. I have had it working like that previously, but something has changed and I don't know what. "Per Jessen" wrote: Hi Open the two workbooks, then goto "Window" "Arrange" select vertical or horizontal Regards, Per On 29 Nov., 15:13, Tom59 wrote: I would like to open two spereadsheets. I want to read one and edit the other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple spreadsheets
Hi,
I find opening two instances (copies) of Excel and put one on each monitor works will. Restore the first one down a little and then move it to the second monitor where you can maximize it. One one file into one copy of Excel and the othe into the second copy of Excel. If this helps, please click the Yes button Cheers, Shane Devenshire "Tom59" wrote: Thank you both for that - Tom. "Chip Pearson" wrote: To use Excel with multiple monitors (I use 4), first resize the Excel application window from maximized to that it stretches across all monitors. Then, open the workbooks. Resize and position each workbook window so that it fills one monitor, one workbook window per monitor. You may want to turn off the multiple task bar items. Go to the Tools menu, choose Options, then the View tab. There, uncheck "Windows In Taskbar". Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 29 Nov 2008 07:55:00 -0800, Tom59 wrote: Thanks Per, this just splits the single window. I have two monitors and would like to use one spreadsheet on one. I have had it working like that previously, but something has changed and I don't know what. "Per Jessen" wrote: Hi Open the two workbooks, then goto "Window" "Arrange" select vertical or horizontal Regards, Per On 29 Nov., 15:13, Tom59 wrote: I would like to open two spereadsheets. I want to read one and edit the other. At the moment, when I open the second spreadsheet, it replaces the first one that I opened. I can see all the different spreadsheets on the task bar, but they all appear to be sharing the same window. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple spreadsheets | Setting up and Configuration of Excel | |||
Open multiple spreadsheets | Excel Discussion (Misc queries) | |||
multiple spreadsheets | Setting up and Configuration of Excel | |||
multiple spreadsheets in Excell | Excel Worksheet Functions | |||
How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions |