Need help setting Excel to display as I would like

[eaglepi]

A problem I have had for a few years now and have not been able to figure it out so I put up with it. When I use Excel 2010 and open more than one worksheet I have troubles finding each worksheet, is there a way to have Excel display a tab for each worksheet so I can switch back and forth easier.

Thanks

 

[Dude]

eaglepi, give this a look

:ar: Tabs for excel

 

[Kaktussoft]

A problem I have had for a few years now and have not been able to figure it out so I put up with it. When I use Excel 2010 and open more than one worksheet I have troubles finding each worksheet, is there a way to have Excel display a tab for each worksheet so I can switch back and forth easier.

Thanks

Are you really talking about worksheets? Or do you mean workbooks? What is a workbook, or a worksheet in MS Excel? | Worldstart's Tech Tips Newsletter

 

[eaglepi]

eaglepi, give this a look

:ar: Tabs for excel

Sorry Dude but I don't see how that helps me, it seems to deal with working with tabs in a worksheet. My problem is when I have one worksheet open and have to open another to copy and paste data from it to the original worksheet I have trouble getting each workbook to be the active workbook.

I have to move the first workbook by grabbing the title bar and moving it until I see the other workbook. There has to be a better way to do this.

 

[eaglepi]

A problem I have had for a few years now and have not been able to figure it out so I put up with it. When I use Excel 2010 and open more than one worksheet I have troubles finding each worksheet, is there a way to have Excel display a tab for each worksheet so I can switch back and forth easier.

Thanks

Are you really talking about worksheets? Or do you mean workbooks? What is a workbook, or a worksheet in MS Excel? | Worldstart's Tech Tips Newsletter

Yes sorry I meant workbooks and I corrected that in my reply to Dude..

 

[Kaktussoft]

eaglepi, give this a look

:ar: Tabs for excel

Sorry Dude but I don't see how that helps me, it seems to deal with working with tabs in a worksheet. My problem is when I have one worksheet open and have to open another to copy and paste data from it to the original worksheet I have trouble getting each workbook to be the active workbook.

I have to move the first workbook by grabbing the title bar and moving it until I see the other workbook. There has to be a better way to do this.

So your talking about workbooks. And you're talking about 1 window of excel running. Correct?
Something like this?

 

[Kaktussoft]

You can use CTRL-TAB to select the next workbook (in current excel window). Or hover over the excel icon on taskbar and select the workbook you want.

 

[eaglepi]

eaglepi, give this a look

:ar: Tabs for excel

Sorry Dude but I don't see how that helps me, it seems to deal with working with tabs in a worksheet. My problem is when I have one worksheet open and have to open another to copy and paste data from it to the original worksheet I have trouble getting each workbook to be the active workbook.

I have to move the first workbook by grabbing the title bar and moving it until I see the other workbook. There has to be a better way to do this.

So your talking about workbooks. And you're talking about 1 instance of excel running. Correct?
Something like this?

Yes I open a workbook and then I download a excel data workbook from my bank. I then try to open the bank data workbook and it opens within the original workbook already open. To find each workbook I have to do as you have shown in your attached image, move the workbooks unitl I can see the 2nd workbook.

If I remember correctly when I learned what I know about Excel which is only enough to do basic stuff. I learned in Excel 2000 long ago and I thought when I opened different workbooks I could change back and forth easier than moving one book to see the other.

 

[eaglepi]

You can use CTRL-TAB to select the next workbook (in current excel instance). Or hover over the excel icon on taskbar and select the workbook you want.

Thansk Kaktussoft for your post that is exactly what I was looking for and it works perfectly. I am sorry Dude for mistyping worksheet rather than workbook. Had I said the proper terms I would have wasted your time.

Thanks to Dude as well.

 

[Kaktussoft]

If excel is already open, the new workbook opens in same excel window as you already saw. WORD doesn't! Powerpoint doesn't!

To open in seperate excel window: open excel again from start menu and keep it opened. Now doubleclick on xls file. Now you have 2 seperate excel instances. You can display both if you want. Even side by side. Even on 2 monitors.

trick to solve it

Office Button > Excel Options > Advanced > General > Ignore Other appli.... ...(DDE)
Check this box. It is probably wise to uncheck it again before closing the last instance of excel...

Excel is still an MDI (Multiple Document Interface) application, while Word and PowerPoint have moved to a modified SDI (Single Document Interface) - the latter run only one instance of the application, but each document has its own application window. This is not possible in Excel.

You can start multiple instances of Excel, but that has several disadvantages:

• It uses more resources.
• Copying / pasting between separate instances is similar to copying / pasting between different applications, so some intelligent Excel features will not work.

 

[eaglepi]

If excel is already open, the new workbook opens in same excel window as you already saw. WORD doesn't! Powerpoint doesn't!

To open in seperate excel instance: open excel again from start menu and keep it opened. Now doubleclick on xls file. Now you have 2 seperate excel instances. You can displaye both if you want. Even side by side. Even on 2 monitors.

trick to solve it

Office Button > Excel Options > Advanced > General > Ignore Other appli.... ...(DDE)
Check this box. It is probably wise to uncheck it again before closing the last instance of excel...

Excel is still an MDI (Multiple Document Interface) application, while Word and PowerPoint have moved to a modified SDI (Single Document Interface) - the latter run only one instance of the application, but each document has its own application window. This is not possible in Excel.
You can start multiple instances of Excel, but that has several disadvantages:

• It uses more resources.
• Copying / pasting between separate instances is similar to copying / pasting between different applications, so some intelligent Excel features will not work.

Thanks for the added reply, I think now with both ways I will not have this problem any longer and once again thank all of you for the help
Ron

 

[eaglepi]

If excel is already open, the new workbook opens in same excel window as you already saw. WORD doesn't! Powerpoint doesn't!

To open in seperate excel instance: open excel again from start menu and keep it opened. Now doubleclick on xls file. Now you have 2 seperate excel instances. You can displaye both if you want. Even side by side. Even on 2 monitors.

trick to solve it

Office Button > Excel Options > Advanced > General > Ignore Other appli.... ...(DDE)
Check this box. It is probably wise to uncheck it again before closing the last instance of excel...

Excel is still an MDI (Multiple Document Interface) application, while Word and PowerPoint have moved to a modified SDI (Single Document Interface) - the latter run only one instance of the application, but each document has its own application window. This is not possible in Excel.


You can start multiple instances of Excel, but that has several disadvantages:

• It uses more resources.
• Copying / pasting between separate instances is similar to copying / pasting between different applications, so some intelligent Excel features will not work.

Thanks for the added reply, I think now with both ways I will not have this problem any longer and once again thank all of you for the help
Ron

Glad you solved it. Why you think my name is Ron?

my name is Ron also and I was just signing my post with my name to thank you guys and make it a bit more personal.