Open Files in a new workbook

  • Thread starter Thread starter TIM HAGEDORN
  • Start date Start date
T

TIM HAGEDORN

I want to have excel set up so when I open a file, it is
opened in a new workbook, not the one I currently have
open. Is there a way to set this up?

Thank you
Tim
 
When you open a file, you are opening a workbook, there is no way to open a file
and have it open a new workbook -- if you want to do that -- jsut open a new
file....


: I want to have excel set up so when I open a file, it is
: opened in a new workbook, not the one I currently have
: open. Is there a way to set this up?
:
: Thank you
: Tim
 
If I have a file open, and I open another file, it opens
in the same excel window. I want to be able to use "alt
tab" to switch between workbooks. If both files are in
the same excel window, this toggle doesn't work. If I
open another excel window and open the second file in that
window, I can toggle. I want to know if there is a way
that when I open a second or third file, that they open in
another window?

Thank you.
 
Use Ctrl tab to switch between the files. You really dont need to have
additional applications running. It slows your system down, you can not use
personalized macros





: If I have a file open, and I open another file, it opens
: in the same excel window. I want to be able to use "alt
: tab" to switch between workbooks. If both files are in
: the same excel window, this toggle doesn't work. If I
: open another excel window and open the second file in that
: window, I can toggle. I want to know if there is a way
: that when I open a second or third file, that they open in
: another window?
:
: Thank you.
:
: >-----Original Message-----
: >When you open a file, you are opening a workbook, there
: is no way to open a file
: >and have it open a new workbook -- if you want to do
: that -- jsut open a new
: >file....
: >
: >
: >"TIM HAGEDORN" <[email protected]>
: wrote in message
: >: >: I want to have excel set up so when I open a file, it is
: >: opened in a new workbook, not the one I currently have
: >: open. Is there a way to set this up?
: >:
: >: Thank you
: >: Tim
: >
: >
: >.
: >
 
With Excel 2000 and newer, you can have Windows in Taskbar.

Tools>Options>View

OR use CRTL + TAB as suggested by Lady Layla.

Gord Dibben Excel MVP
 
Back
Top