MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Two questions about Excel


Posted by Larry Stoy on June 13, 2001 6:45 PM

1) When I have an Excel workbook open and go to open another workbook, they open in seperate windows. How do I get them to open just using one window?

2) When I use my Scroll Wheel in Excel, it changes the Zoom in and out! How do I make the Scroll Wheel actually scroll?


Posted by steve w on June 13, 2001 8:21 PM

try going to tools/options/general and unclick the zoom on roll of intellimouse
hope this helps.
Now about your first questine I don't think its posible, I think it has to open another window. What is the reson to have it open in the same window, maybe I can help with an alternative.

Let me know
steve w

Posted by Larry Stoy on June 13, 2001 9:34 PM

1) When I have an Excel workbook open and go to open another workbook, they open in seperate windows. How do I get them to open just using one window?


Thanks for the tip on the mouse..it worked.

Now, the other question. When I go to open a second worksheet, it's like I'm opening a second Excel program. It shows two spreadsheets on my Task Bar and if I go to close the second spreadsheet (using the top "X") it closes Excel altogether. Shouldn't Excel just open the spreadsheet without acting like it's opening another program?

Posted by Richard S on June 13, 2001 10:32 PM

I believe you're using windows 2000. If you click on Window in Excel, you will see that both sheets are open in the same copy of Excel. There is only one copy running, it's just that Windows 2000 displays it as two tasks on the task bar. When you click on the top "x", it closes Excel, only one copy open, so both worksheets close. Click on the lower "x" to close the active worksheet.

Posted by Larry Stoy on June 14, 2001 3:17 AM

I'm using Windows98. And at work, I use Windows98 also. There, I can open several worksheets and I only see one icon on the Task Bar that represents Excel, no matter how many worksheets I have open.

Posted by Ivan F Moala on June 14, 2001 6:28 AM


If you are using excel2000 then there is an option
in Tools / Options / View = Windows in taskbar
Just deselect this to get more then one icon
for excel.


Ivan


Posted by Larry Stoy on June 15, 2001 7:26 PM


Thanks, I figured this out at work yesterday. Even the IS department couldn't remember how to do this!