Multiple spreadsheets

  • Thread starter Thread starter Tom59
  • Start date Start date
T

Tom59

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.
 
Hi

Open the two workbooks, then goto "Window" > "Arrange" select vertical
or horizontal

Regards,
Per
 
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.
 
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)
 
Thank you both for that - Tom.

Chip Pearson said:
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)
Click to expand...
 
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
 
Back
Top