Viewing spreadsheet data in a split window

DorenM · Mar 27th, 2002, 08:46 PM

Hello!

Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately.

Any suggestions would be greatly appreciated!
Thanks!

SamS · Mar 27th, 2002, 09:27 PM

Quote:

On 2002-03-27 20:46, DorenM wrote:
Hello!

Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately.

Any suggestions would be greatly appreciated!
Thanks!

Have you tried Window, New Window, Arrange, Vertical

This will give you 2 windows with the same workbook and you can have the same worksheet in both windows

DorenM · Mar 28th, 2002, 02:25 PM

Thanks Sam! That works well, as long as all the rows are the same height. (I'm comparing data from one window to the other, so need the rows to line up.)

Thanks again!
D.

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

Mar 27th, 2002, 08:46 PM	#1
DorenM New Member Join Date: Mar 2002 Posts: 3	Hello! Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately. Any suggestions would be greatly appreciated! Thanks!

Mar 28th, 2002, 02:25 PM	#3
DorenM New Member Join Date: Mar 2002 Posts: 3	Thanks Sam! That works well, as long as all the rows are the same height. (I'm comparing data from one window to the other, so need the rows to line up.) Thanks again! D.