viewing more than one workbook at a time

Carole · Apr 25th, 2002, 10:06 AM

Can I view two spreadsheets that I have open at the same time ? Also can I move down data in one and the other spreadsheet moves down the list at the same time? To easily compare data.

Asala42 · Apr 25th, 2002, 10:43 AM

G'day,

Window/Arrange will allow you to view 2 windows at once, but I'm not sure of a why to get both to scroll the same way.

Sorry I couldn't be more help,
Adam

Asala42 · Apr 25th, 2002, 10:44 AM

oops,

why = way

klb · Apr 25th, 2002, 11:49 AM

If the data in both worksheets are at the same place in each, you could use a separate sheet to show the values that you want to compare in adjoining cells.

Cell A1 would contain the information from worksheet1 and cell B1 would contain the information from worksheet2. Then copy the formulae down the columns and view them that way. Make sure you remove the $ from your first formula so that it copies the relative addresses from each worksheet.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 10:06 AM	#1
Carole New Member Join Date: Apr 2002 Location: Carole Posts: 8	Can I view two spreadsheets that I have open at the same time ? Also can I move down data in one and the other spreadsheet moves down the list at the same time? To easily compare data.

Apr 25th, 2002, 10:43 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	G'day, Window/Arrange will allow you to view 2 windows at once, but I'm not sure of a why to get both to scroll the same way. Sorry I couldn't be more help, Adam

Apr 25th, 2002, 10:44 AM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	oops, why = way

Apr 25th, 2002, 11:49 AM	#4
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	If the data in both worksheets are at the same place in each, you could use a separate sheet to show the values that you want to compare in adjoining cells. Cell A1 would contain the information from worksheet1 and cell B1 would contain the information from worksheet2. Then copy the formulae down the columns and view them that way. Make sure you remove the $ from your first formula so that it copies the relative addresses from each worksheet.