ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to display two spreadsheets next to each other (https://www.excelbanter.com/excel-discussion-misc-queries/25927-how-display-two-spreadsheets-next-each-other.html)

PeterM

How to display two spreadsheets next to each other
 
I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get 2
spreadsheets next to each other, but I need to manipulate them separately. I
need to cut and paste between them. Please let me know how to accomplish
that..............I'm using Win xp home and use Office 2003 Std
edition.....Thanks.......Peter


JE McGimpsey

With both workbooks open, choose Window/Arrange... Click the Vertical
radio button, then click OK.

In article ,
"PeterM" wrote:

I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get 2
spreadsheets next to each other, but I need to manipulate them separately. I
need to cut and paste between them. Please let me know how to accomplish
that..............I'm using Win xp home and use Office 2003 Std


Bill Kuunders

I assume you are working with two seperate files.

Open them both and go to the menu <window<arrange
select tiled vertical or horizontal

--
Greetings from New Zealand
Bill K

"PeterM" wrote in message
...
I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get 2
spreadsheets next to each other, but I need to manipulate them separately.
I need to cut and paste between them. Please let me know how to accomplish
that..............I'm using Win xp home and use Office 2003 Std
edition.....Thanks.......Peter




Debra Dalgleish

If you want to view two sheets in the same workbook:

Choose WindowNew Window
Choose WindowArrange
Select Vertical, and add a check mark to 'Windows of active workbook'
Click OK
In one of the windows, click on a different sheet tab

PeterM wrote:
I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get
2 spreadsheets next to each other, but I need to manipulate them
separately. I need to cut and paste between them. Please let me know how
to accomplish that..............I'm using Win xp home and use Office
2003 Std edition.....Thanks.......Peter



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


PeterM

Thanks to all of you, how sweet it is, finally back to where I couldn't get
back to....You guys and gals are so wonderful.................Peter

"Debra Dalgleish" wrote in message
...
If you want to view two sheets in the same workbook:

Choose WindowNew Window
Choose WindowArrange
Select Vertical, and add a check mark to 'Windows of active workbook'
Click OK
In one of the windows, click on a different sheet tab

PeterM wrote:
I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get
2 spreadsheets next to each other, but I need to manipulate them
separately. I need to cut and paste between them. Please let me know how
to accomplish that..............I'm using Win xp home and use Office 2003
Std edition.....Thanks.......Peter



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



paul

its even easier than that,windowcompare side by side with....
--
paul
remove nospam for email addy!



"PeterM" wrote:

I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get 2
spreadsheets next to each other, but I need to manipulate them separately. I
need to cut and paste between them. Please let me know how to accomplish
that..............I'm using Win xp home and use Office 2003 Std
edition.....Thanks.......Peter




All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com