how to open and see 2 excel work sheets at a time

  • Thread starter Thread starter Guest
  • Start date Start date
Open both workbooks normally and then go to the Window menu and
choose the layout you prefer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I don't think you'll get many responses by not asking a question in the body
of the post. that is presuming it is a question and not a statement.

There having got that off my chest, and seeing it is almost Christmas,
here's what to do;

Open the first worksheet.
Open the second one.
Click on Window in the Toolbar.
Click OK and both sheets will be displayed side by side.

You have several options on how the sheets are displayed.

Happy Christmas!

--
Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..
 
Seems to me your talking two sheets (in the same book), not two books; if
so,
go to the menu, Window, New Window (Where your existing
window(file)name is Myfile(.xls) you will now see Myfile:2
Your original sheet is automatically named Myfile:1;
Go now back to the menu, Window, Arrange.. Clk Vertical and
Windows of active workbook.
Save File.
HTH
Jim May
 
You must log in or register to reply here.

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
Seeing Two Different Excel Files At Once: How, please ? 2
EXCEL WORK BOOK DUPLICATES WHEN OPENED 1
Merge Multiple workbook sheets into one workbook 0
New instance of Excel when opening different sheets 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Start sheet in a workbook 2
Excel 2007 - Closing One Sheet at a Time? 5

Back
Top