working spreadsheet two windows
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Working with spreadsheet in two windows.

Working with spreadsheet in two windows.

resolvedResolved · Medium Priority · Version 2002/XP

replyReply Wed 8 Sep 2010, 12:06Delegate Gabriela said...

Gabriela has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course

Working with spreadsheet in two windows.

I work with two computer screens and I can not manage to open two windows. I have applied what I learned in the course but it actually did not work with excel aplication in the computer I use at work. Any idea what could be causing this obstacle?

For upcoming training course dates see: Pricing & availability

replyReply Wed 8 Sep 2010, 20:01Trainer Newson said...

RE: Working with spreadsheet in two windows.

Hi Gabriela

I'm assuming this works with other applications on your PC and that you have setup your display properties in control panel correctly. Here is a link from Microsoft describing how to to configure multiple monitor support in Windows XP http://support.microsoft.com/kb/307873.

To ensure Excel displays more than one windows for each book that is opened go to
Tools-Options.
Select the View Tab
and just below in the Show area check Windows in Taskbar.


You should now be able to see multiple windows when more than one book is opened in Excel. You should now be able to drag one of the Windows to your extended desktop and it should display on the second screen.


If that doesn't help please don't hesitate to get back to me

Many thanks

Newson

replyReply Wed 8 Sep 2010, 20:01Trainer Newson said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

 

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

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard