![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Feb 2002
Posts: 4
|
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 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
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 |
|
New Member
Join Date: Feb 2002
Posts: 4
|
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 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Houston, TX
Posts: 303
|
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 |
|
New Member
Join Date: Feb 2002
Posts: 4
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Chippenham, UK
Posts: 136
|
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 |
|
New Member
Join Date: Feb 2002
Posts: 4
|
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 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
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" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|