Showing All Excel Workbooks on the Taskbar

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

 

Technorati Tags: Office,Office 2003,Office 2007,Office 2010,Excel,Excel 2003,Excel 2007,Excel 2010,show workbooks on taskbar

del.icio.us Tags: Office,Office 2003,Office 2007,Office 2010,Excel,Excel 2003,Excel 2007,Excel 2010,show workbooks on taskbar