Dual montiors and Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Dual montiors and Excel

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm running W2000, Office 97, with dual monitors and a Matrox video board. While I can open Excel across both screens and display two side by side worksheets, I can not stretch a single worksheet across both screens in order to see more cells to the right. Any suggestions?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    A guy i work with does this for WWW so have history showing all the time and loves it!

    Can you not make view 200%, or as reqd>


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Changing zoom to 200% makes no difference. Problem is I can't stretch the worksheet out beyond about a half inch past the first monitor.

    In all other applications I can display a document or screen across both monitors. It is only with Excel that I have the problem. Again, the application fills both monitors, but the individual workbook/worksheet can not be expanded.

    I'm baffeled. Richman

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    H

    Sadle im at a loss ill ask my pal tommorow??

    See if that helps... get him to run Excel also
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know exactly what you mean. I have one monitor resolution set very high and while the Excel window can be maximized to fill the screen, the spreadsheet window when maximzed doesn't fill the Excel window.

    I posted below recently and haven't gotten any responses. Have you had this problem, too?

    -------------------------------------------
    This has been bugging me for a while. I have 2 monitors (WIN98) with Excel 97 usually running maximized on right monitor. Some dialog boxes such as File Open don't like this. The initial dialog box opens on the Excel monitor (right). If I choose the dropdown box to change directories, the directory tree opens on the left monitor. No matter what I choose from the tree on the left monitor, the choice is not updated in the dialog box on the right. The only way I've found to make this work is to drag the original dialog box to the left monitor and proceed with selection. Is this weird or what?

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, I've had the same problem with dialog boxes. I can live with that one although it is an irritant.

    Regarding Excel, it appears there is a real limitation as to the display size of worksheets. We both have similar problems.

    Thanks

    Richman

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    One way of getting round the problem would be to open a new window of the same sheet.

    Right click on the Excel icon next to the file menu and click on new window. Drag the second window onto your second monitor.


    Regards,

    Gary Hewitt-Long

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yup, I routinely use that trick to expand the worksheet and it works pretty well but it just seems to me there should be away to expand a single sheet across two or three monitors.

    I can even expand a word document, go figure!

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    HI __

    Sorry for delay but as promised, i have spoken to pal with dual mointer and all..

    Yeah! Excel dont seem to like it.. no ideas why, no fix im very sorry, Odd PowerPoint and Word were fine..... ERmmmmmmmm.

    One for Bill Gates that.. Maybe Excel cant!

    Rdgs
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com