how do i open excel files in different worksheets?

C

camila

when i open more than one .xls file excel open them in the same worksheet,
different windows, but the same worksheet. And i want to view my files
independently.

I does not work the arranging windows button, because it still give me
arranges in the same worksheet.

Thanks
 
G

George Nicholson

MyBook.xls is open, in one window. Then:
Window> NewWindow (pre-2007 menu command. No idea what the ribbon
equivalent is)

You now have 2 windows that can be arranged:
MyBook.xls
MyBook.xls:2
(Once a 2nd window is open, the "Window>CompareSideBySideWith..." command
becomes available, which allows you to synchronize scrolling between
windows.)

Keep in mind that you still have the same number of file(s) open, you are
only increasing the number of windows available to view those files.
 

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

WOrksheets 2
Cannot copy worksheet to another file 2
how do i combine excel worksheets 1
Open .xlsx files in Excel 2002 2
Seeing Two Different Excel Files At Once: How, please ? 2
How to open two Excel files in separate windows? 4
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Links are different depending on how you open file. 3

Top