Welcome to the US SMB&D TS2 Team Blog

Helping partners understand the value of Microsoft solutions.

Showing All Excel Workbooks on the Taskbar

Showing All Excel Workbooks on the Taskbar

  • Comments 15
  • Likes

Q: (from Phyllis)

I have been trying to find the default setting in Excel for automatically opening multiple instances when a new workbook is opened. I can manually open them. I am on Windows 7 Pro and Office 2007. Can you give me a shove in the right direction?

 

A:

It’s interesting – Word and PowerPoint do this by default, but historically speaking, Excel doesn’t. All of the workbooks are associated with the same taskbar icon and therefore making it difficult to show two workbooks side-by-side in Windows 7. We seem to have added an option to correct this starting with Office 2003 and from page 8 of my Tips & Tricks document (https://skydrive.live.com/?cid=9dc1b9c3c6b95b61#!/view.aspx?cid=9DC1B9C3C6B95B61&resid=9DC1B9C3C6B95B61%21892) I believe the following should work:

Show each open spreadsheet on the taskbar (Excel 2007)

  • Select the Office Start button clip_image002
  • Select the Excel Options button clip_image004
  • Select the Advanced from the left-hand list
  • Scroll down to the Display section
  • Check the Show all windows in the taskbar checkbox

Click the OK button

 

SDeming Face Steve

 

Comments
  • Thanks so much for this info!  This function was not checked when I switched to excel 2007 and it has drove me crazy.

  • Hey, actually that does work for showing them on the task bar (i'm using office 2010) but unfortunately the problem is not solved as excel still groups the multiple instances in the window, not allowing one to view 2 windows side by side unless minimizing the both instances and resizing within the excel window. There has go to be a way to fix this!! absolutely moronic...

  • Perhaps the Windows option to group similar taskbar buttons together may be relevant here? See this article:

    Group similar buttons on the taskbar

    windows.microsoft.com/.../Group-similar-buttons-on-the-taskbar

  • Its possible to change it also in office 2013?

  • Excel is just so different! If an Excel window is closed through the Live Taskbar Preview, then the Live Taskbar Preview also closes! But with Word or IE when a window is closed through the Live Taskbar Preview, then the Live Taskbar Preview just resizes. Is this an intentional anomaly in Excel? or just Excel being different?

  • Thanks. It worked  and problem resolved.

  • This was a great help - simple and concise. Thank you!

  • Thanks steve...it worked

  • Marvellous. I recently upgraded and so I did this in reverse, which is what I wanted to achieve, i.e. only one item on the taskbar and switch workbooks by using the CTRL-TAB or following these daft 'ribbon' menus to Switch Window.

  • Thanks Steve

  • Thanks Steve. its working

  • The fix is quick.
    Go to windows taskbar properties and change the option from "Always combine, hide labels" to never combine.
    Hit apply and the excel windows will show on the bar side by side.

  • Thank you very much.

  • Thanks steve its working

  • Thx explained simple and clear.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment