Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel multi screen functionality

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel multi screen functionality

Resolved · High Priority · Version 2007

Reply Thu 24 Nov 2011, 17:11Delegate Pankaj said...

Pankaj has attended:
Excel Advanced course

Excel multi screen functionality

I have two work screens. Can I open two different Excel sheets on two screens so that I could compare things conveniently?

For upcoming training course dates see: Pricing & availability

Reply Fri 25 Nov 2011, 11:20Trainer Simon said...

RE: Excel multi screen functionality

Hi Pankaj,

Thank you for your question.

It should be possible by going to the View Tab on the ribbon and in the Window group choose New Window. This creates a new window dfor the same workbook (Book1:1 and Book1:2). You can then change the sheet on the Book1:2, click restore and drag that window onto the second monitor.

Please find the link below:

http://www.excelforum.com/excel-general/548353-dual-monitors-viewing-different-tabs-in-same-workbook.html

I hope this answers your question.

Regards

Simon

Reply Fri 25 Nov 2011, 11:32Delegate Pankaj said...

RE: Excel multi screen functionality

Hi Simon,

Many thanks for your prompt reply. I tried following the instructions - opened a new window, unmaximise the two sheet successfully but can not drag to the second screen. Everything stays in one screen only. Hence, when I expand, it opens in one screen again. May be I am missing some step. Do you know where things are getting wrong?

Kind regards,

Pankaj

Reply Fri 25 Nov 2011, 14:41Trainer Simon said...

RE: Excel multi screen functionality

Hi Pankaj,

I really thought that would have worked but as I have no way of testing this it is hard to answer this one. As this doesn't work I may be inclined to assume it can't be done.

What I advise you do is have a look on the Excel forums and see if anyone has found a solution.

I will keep looking and if I come across anything I will email you back.

Regards

Simon

Thu 1 Dec 2011: Automatically marked as resolved.

Excel articles

· Create A Basic Timeline In Excel
· A Quick Guide To Conditional Formatting In Excel 2007/2010
· Charting Another Dimension With Excel
· Securing Critical Company Information With Simple Visual Basic Training Courses
· Why Should I Learn Visual Basic in Excel?

Please browse our web site to find out more about
advanced excel ms training and other Microsoft training courses.

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips