Opening more than 1 Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure if this is an Excel problem, but it doesn't do it in any of the
other software applications. If I have more than one Excel file open at a
time, I only get one tab on the bottom of my workspace instead of multiple
tabs. They are all stacked behind one open Excel spreadsheet which is really
messy and confusing to have to open them one at a time and close the others
in order to access them. Word doesn't do this and I can't find out what to
change to get out of this "stacking". Suggestions are welcome.
 
This happens to me when I have too many OTHER windows open, along with
several Excel documents. It'll stack them like that when there is no more
room on the taskbar to show them side-by-side. Depending on the size of your
monitor and the resolution, there will be more or less room for different
windows. For example, at work I have a 17" monitor set at 1024x768, and I can
have five different "tabs," as you say, in the taskbar. Change the settings
to 800x600, and then I can only have 4 tabs visible, and like programs are
stacked. That's just what it does. At home, on my 19", I can have 7 "tabs."

So, try closing other programs you have open or change your monitor
settings. Right click on the desktop and go to properties>settings>screen
resolution.
 
Oh, and I totally forgot. You can change the taskbar properties. Right-click
the taskbar, and select properties unchceck "group similar taskbar buttons."
That'll fix the stacking..
 
OH! And you can change the taskbar settings. Right-click on the taskbar and
go to properties. Uncheck the box that says "group similar taskbar buttons."
That'll fix it.
 
Catlady,

I think when you say "tab" you're referring to taskbar buttons on the taskbar. If you want
to see one button for each workbook that's open, do Tools - Options - View tab, and check
"Windows in taskbar." This has nothing to do, by the way, with sheet tabs, of which there's
one for each sheet in a workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel spreadsheets opening at top instead of bottom. 4
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Open Multible Instances of Excel 3
View more than 1 spreadsheet at a time in Excel? 5
Opening Excel Spreadsheets 1
Manage a high number of worksheets in one workbook (Excel 2007) 4
Excel 2007 Two Spreadsheets Together 2

Back
Top