MrExcel Message Board

Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

Reply
 
Thread Tools Display Modes
Old Feb 26th, 2002, 12:09 PM   #1
Richman20
New Member
 
Join Date: Feb 2002
Posts: 4
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?
Richman20 is offline   Reply With Quote
Old Feb 26th, 2002, 12:20 PM   #2
Jack in the UK
Board Regular
 
Join Date: Feb 2002
Posts: 3,064
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"
Jack in the UK is offline   Reply With Quote
Old Feb 26th, 2002, 12:53 PM   #3
Richman20
New Member
 
Join Date: Feb 2002
Posts: 4
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
Richman20 is offline   Reply With Quote
Old Feb 26th, 2002, 01:01 PM   #4
Jack in the UK
Board Regular
 
Join Date: Feb 2002
Posts: 3,064
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"
Jack in the UK is offline   Reply With Quote
Old Feb 26th, 2002, 02:44 PM   #5
pilot
Board Regular
 
Join Date: Feb 2002
Location: Houston, TX
Posts: 303
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?
pilot is offline   Reply With Quote
Old Feb 26th, 2002, 02:59 PM   #6
Richman20
New Member
 
Join Date: Feb 2002
Posts: 4
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
Richman20 is offline   Reply With Quote
Old Feb 26th, 2002, 03:03 PM   #7
gplhl
Board Regular
 
Join Date: Feb 2002
Location: Chippenham, UK
Posts: 136
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
gplhl is offline   Reply With Quote
Old Feb 26th, 2002, 03:10 PM   #8
Richman20
New Member
 
Join Date: Feb 2002
Posts: 4
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!
Richman20 is offline   Reply With Quote
Old Feb 27th, 2002, 11:59 AM   #9
Jack in the UK
Board Regular
 
Join Date: Feb 2002
Posts: 3,064
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"
Jack in the UK is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 06:56 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
All contents Copyright 1998-2012 by MrExcel Consulting.
diabetic desserts recipes recipes Diabetic Soups Holiday Pizza Recipes Popcorn Recipes Recipes For Microwave Pasta Recipes Casserole Recipes Chili Recipes Curry Recipes Crockpot Recipes Apples Recipes Bread Recipes Vegetarian Recipes Vegetable recipes Desserts Recipes Appetizers Ethnic Recipes Meat Dishes Barbecue Recipes Sauces Recipes Marinade Recipes Low Fat Recipes Frugal Gourmet Kitchen Classics Recipes On The Grill Cook Books Seafood Recipes Cajun Recipes Breads Low Fat Low Fat Breads Bread Machine Recipes Yeast Breads Quick Breads Fat Free Vegetarian Salad Recipes Eggplant Recipes Radish Recipes Tomato Recipes Jalapeno Recipes Potato Recipes Lettuce Recipes Cabbage Recipes Beans Ambrosia Recipes Biscotti Recipes Desserts Low Fat Cookie Recipes Cheesecake Recipes Cake Recipes Pie Recipes Muffin Recipes Custard Recipes Best Appetizers Appetizers Low Fat Salsa Recipes Dip Recipes International Recipes Afghan Recipes Alaska Recipes French Recipes German Recipes Greek Recipes Italian Recipes Spanish Recipes Thai Recipes Korean Recipes Chinese Recipes Mexican Recipes Indian Recipes Beef Recipes Pork Pork & Ham Pork Butts Pork Chop Recipes Pork Ribs Rulled Pork Poultry Recipes Stews Recipes Ground Beef Barbecue Grill Barbecue Smoker All Purpose Sauce BBQ Sauce Barbecue Sauce Carolina BBQ Sauce Pickle Recipes Marinades Smoking Low Fat Appetizers & Dips Low Fat Breakfast Low Fat Cakes Low Fat Cheesecakes Low Fat Cookies Low Fat Desserts Low Fat Fish & Seafood Low Fat Meats Low Fat Pasta Low Fat Pies Low Fat Salads Low Fat Sandwiches Low Fat Sauces & Condiments Low Fat Sides Low Fat Soups Low Fat Vegetarian Baker's Dozen Taste of Home Recipe Book Bon Appetit Cookbook Blacktie Cookbook Buster Cook Book Cookbook USA Cook Book Cook Book Sara's Cookbook Sara's Cookbook Appetizers and Dips Poultry recipes Diabetic recipes Holiday recipes Miscellaneous recipes 110 recipes 1986 Usenet cookbook 2900 recipes Cyberrealm recipes Great sysops of world Specialty recipes Ceideburg recipes Cheese recipes Chili recipes Fruits recipes Garlic recipes Great chefs of NY Londontowne recipes Raisins recipes Recipes for kids US Food Vegetarian recipes Bread recipes Drinks Meat Dishes Brisket recipes Caribou recipes Chicken recipes Filet mignons recipes Pork recipes Swordfish recipes Turkey recipes Pasta recipes Uncategorized recipes Ethnic recipes Canada recipes English recipes Ethiopia recipes Germany recipes Greece recipes Mexican recipes Philippines recipes Welsh recipes Microwave recipes Soups recipes Vegetable recipes Asparagus recipes Barley recipes Brown rice recipes Lentil recipes Mushrooms recipes Salads recipes Wild rice Desserts recipes Cakes recipes Chocolate recipes Cookies recipes Ice cream recipes