Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Need help setting Excel to display as I would like


08 May 2013   #1

Windows 7 ultimate
 
 
Need help setting Excel to display as I would like

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

My System SpecsSystem Spec
.

08 May 2013   #2

Windows 8.1 Pro | Windows 7 Home Premium 64-bit SP1
 
 

eaglepi, give this a look

Tabs for excel
My System SpecsSystem Spec
08 May 2013   #3

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by eaglepi View Post
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
My System SpecsSystem Spec
.


08 May 2013   #4

Windows 7 ultimate
 
 

Quote   Quote: Originally Posted by Dude View Post
eaglepi, give this a look

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.
My System SpecsSystem Spec
08 May 2013   #5

Windows 7 ultimate
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
Quote   Quote: Originally Posted by eaglepi View Post
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..
My System SpecsSystem Spec
08 May 2013   #6

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by eaglepi View Post
Quote   Quote: Originally Posted by Dude View Post
eaglepi, give this a look

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?


Attached Thumbnails
Need help setting Excel to display as I would like-naamloos.png  
My System SpecsSystem Spec
08 May 2013   #7

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

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.
My System SpecsSystem Spec
08 May 2013   #8

Windows 7 ultimate
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
Quote   Quote: Originally Posted by eaglepi View Post
Quote   Quote: Originally Posted by Dude View Post
eaglepi, give this a look

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.
My System SpecsSystem Spec
08 May 2013   #9

Windows 7 ultimate
 
 

Quote   Quote: Originally Posted by Kaktussoft View Post
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.
My System SpecsSystem Spec
08 May 2013   #10

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

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.
My System SpecsSystem Spec
Reply

 Need help setting Excel to display as I would like




Thread Tools



Similar help and support threads for2: Need help setting Excel to display as I would like
Thread Forum
Excel 97 display distorted in Win7 Microsoft Office
Get prices from certain websites and display in excel Microsoft Office
Office 2007Word/ Excel wil not display Help Menu Microsoft Office
Excel 2000 display issues Microsoft Office
Problem setting up second display Hardware & Devices
setting up dual display Graphic Cards
Troubleshoot on VM Display setting Virtualization

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:48 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33