Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 23rd 04, 07:07 PM
cwm
 
Posts: n/a
Default how to open and see 2 excel work sheets at a time



  #2   Report Post  
Old December 23rd 04, 07:18 PM
Chip Pearson
 
Posts: n/a
Default

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


"cwm" wrote in message
...



  #3   Report Post  
Old December 23rd 04, 07:19 PM
Ken Russell
 
Posts: n/a
Default

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


Remove yourhat to reply by e-mail
..

"cwm" wrote in message
...



  #4   Report Post  
Old December 26th 04, 01:27 PM
Jim May
 
Posts: n/a
Default

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



"Ken Russell" wrote in message
...
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


Remove yourhat to reply by e-mail
.

"cwm" wrote in message
...







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017