Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel worksheets on two monitors

Thread Tools
 
Search this Thread
 
Old 24 August 2009, 03:17 PM
  #1  
dunx
Scooby Senior
Thread Starter
iTrader: (3)
 
dunx's Avatar
 
Join Date: Jun 2006
Location: Slowly rebuilding the kit of bits into a car...
Posts: 14,333
Likes: 0
Received 0 Likes on 0 Posts
Default Excel worksheets on two monitors

Excel worksheets on two monitors, is this possible ?

When I try to open the second it's "glued" to screen one.

TIA

dunx
Old 24 August 2009, 03:38 PM
  #2  
ScoobyJawa
Scooby Regular
 
ScoobyJawa's Avatar
 
Join Date: Aug 2001
Location: Hampshire
Posts: 10,954
Likes: 0
Received 0 Likes on 0 Posts
Default

You can yeah theres a few pages on the net that tell you how. There are some tweaks you can do, me I can't be bothered so all I do is:

double click first file - opens excel.

Then just go into Start - Programs - Office and click excel (not by double clicking another different file) and this starts up a separate excel process so you can have on 2 windows
Old 24 August 2009, 04:53 PM
  #3  
dunx
Scooby Senior
Thread Starter
iTrader: (3)
 
dunx's Avatar
 
Join Date: Jun 2006
Location: Slowly rebuilding the kit of bits into a car...
Posts: 14,333
Likes: 0
Received 0 Likes on 0 Posts
Default

Thanks very much, you've made an old woman very happy, a colleague NOT me !

dunx

P.S. This works fine at home for me, but at work I can't drag the window onto the second monitor.... need to dig into the settings methinks.

Last edited by dunx; 24 August 2009 at 06:13 PM.
Old 25 August 2009, 10:20 AM
  #4  
dunx
Scooby Senior
Thread Starter
iTrader: (3)
 
dunx's Avatar
 
Join Date: Jun 2006
Location: Slowly rebuilding the kit of bits into a car...
Posts: 14,333
Likes: 0
Received 0 Likes on 0 Posts
Default

Worked this one out by watching said "wimmens".....

She ONLY ever opens by clicking on the file, not the program in the start menu.

All works fine, but RM IT support couldn't work this one out !

I also said she could have three monitors, two for excel and one for e-mails, but again IT support said "You can't have three monitors... because you don't have enough desk space." I despair....

dunx
Old 25 August 2009, 11:14 AM
  #5  
StickyMicky
Scooby Regular
 
StickyMicky's Avatar
 
Join Date: Feb 2003
Location: Zed Ess Won Hay Tee
Posts: 21,611
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by ScoobyJawa
You can yeah theres a few pages on the net that tell you how. There are some tweaks you can do, me I can't be bothered so all I do is:

double click first file - opens excel.

Then just go into Start - Programs - Office and click excel (not by double clicking another different file) and this starts up a separate excel process so you can have on 2 windows
That is the way i did it when i was running 2 monitors
Old 25 August 2009, 11:19 AM
  #6  
mr_D
Scooby Regular
iTrader: (12)
 
mr_D's Avatar
 
Join Date: Mar 2009
Location: in a house
Posts: 2,078
Likes: 0
Received 0 Likes on 0 Posts
Default

you can move them around as long as they are of the smaller size windows? are you not abel to do it even then?
Old 25 August 2009, 07:43 PM
  #7  
HHxx
Scooby Regular
 
HHxx's Avatar
 
Join Date: Nov 2001
Posts: 2,576
Likes: 0
Received 0 Likes on 0 Posts
Default

Assuming you don't mean 2 worksheets from the same workbook?

Which version of office? I haven't worked it out or researched Excel 2007 yet, but when I had office 2003 on XP, you can set the xls file type to not 'browse in same window' or something.

This should mean a new instance of Excel every time you just double clicked a spreadsheet.
Old 25 August 2009, 08:34 PM
  #8  
dunx
Scooby Senior
Thread Starter
iTrader: (3)
 
dunx's Avatar
 
Join Date: Jun 2006
Location: Slowly rebuilding the kit of bits into a car...
Posts: 14,333
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by dunx
Worked this one out by watching said "wimmens".....

She ONLY ever opens by clicking on the file, not the program in the start menu.
It's all about how she was opening the file, not running the application, and then opening the file within the application....

Sorted easily, but way beyond IT guys ability to understand/explain.....

dunx
Old 26 August 2009, 03:18 PM
  #9  
markr1963
Scooby Regular
 
markr1963's Avatar
 
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes on 0 Posts
Default

For flipping apps from monitor to monitor and some other good stuff take a look at UltraMon
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
T.K
General Technical
10
02 October 2015 11:35 AM



Quick Reply: Excel worksheets on two monitors



All times are GMT +1. The time now is 06:37 PM.