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
eaglepi

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
Dude

Windows 8.1 Pro + Windows 10
 
 

eaglepi, give this a look

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

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
eaglepi

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
eaglepi

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
Kaktussoft

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

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
eaglepi

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
eaglepi

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
Kaktussoft

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
Thread Forum
How to revert the setting of Excel 2010 to its default
Hi, When someone changes the settings of a Microsoft Excel 2010 file, how to recover its default settings? I've used Microsoft Fixit tool and also repairing the Office from Uninstall or change a program. Both didn't worked!
Microsoft Office
Display not refreshed when scrolling excel spreadsheet
Help, my excel spreadsheets (not large) do not display properly when I scroll. Some lines repeat, other do not refresh. I minimize the window then maximize it, and it displays OK, but after when I scroll, Excel does not refresh or update the cells properly. The worst case is having a screen...
Graphic Cards
Excel 97 display distorted in Win7
I've got 3 Windows 7 netbooks & 1 Win 7 laptop. When installing Office 97 on them I get mixed results. All looks fine during the installation. But once the initial reboot happens, the cells in the Excel sheets are more square and compact that the usual cells (see screenshot) . On one of the...
Microsoft Office
Office 2007Word/ Excel wil not display Help Menu
I am running Office 2007 (in x86) on Windows 7 and when I try to open the Help menu in Word or Excel I first get a dialog box that asks me if I want to save a file called transitions.htm. No matter if I say Save or Cancel the Help box opens blank. It says it is "connnected to Office Online," but...
Microsoft Office
Excel 2000 display issues
Has anyone encountered this issue before with Excel 2000 in Windows 7 (professional 32bit). We are testing windows 7 on some Pc, and those users are using Office 2000. Everything works fine, however, sometimes users launch excel (by double clicking on an XLS file) and excel come up like the...
Microsoft Office
Troubleshoot on VM Display setting
Hi, at first I wasn't sure were to place that thread. So I'm sorry if its wrong here. I need to know were I can change the "Hardware Beschleunigung" (I guess its called "hardware acceleration" or "hardware speedup"). I hoped to find it within the display settings > advanced > troubleshoot...
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 23:27.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App