How to display two spreadsheets next to each other

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

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
 
With both workbooks open, choose Window/Arrange... Click the Vertical
radio button, then click OK.
 
I assume you are working with two seperate files.

Open them both and go to the menu <window><arrange>
select tiled vertical or horizontal
 
If you want to view two sheets in the same workbook:

Choose Window>New Window
Choose Window>Arrange
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
 
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
 
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

open spreadsheets into separate excel instance 1
how do I merge data from separate spreadsheets 1
How to open two Excel files in separate windows? 4
How to get each spreadsheet to open in a seperate process? 3
How to move data from spreadsheets to spreadsheet? 2
how do i add tabs to an open excel spreadsheet? 1
how to protect master spreadsheet from corruption? 4
Macro ?-moving info from 1 sheet to first blank section on another 6

Back
Top