making frames in a spread sheet?

[jaymai108]

Does any one know how to make a spreadsheet in to frames? i tried
freeze pane but what i really want is to separate the worksheet into
frames like a webpage, so if i scroll down the right side, the left
side and the top side won't mvoe...

thanks
jay

 

[Gord Dibben]

I think about the closest you can get is to have two vertically positioned
windows side by each.

The active window will scroll but inactive will remain stationary.

Excel has no "frames" feature like a webpage.


Gord Dibben MS Excel MVP

 

[zz]

window---split

divides the spreadhseet in four separate "frames", you can drag the splits
vertically or horizontally to show only the two of them you want.

 

[susiedba]

Excel ins't a software development tool; it's not as powerful as
Access.

In Excel if you want to copies of data; sorted in different directions;
then you need 2 copies of the data.

Databases can sort data in different directions without duplicating /
growing the file SIZE.

-Aaron

 

[zz]

I think jaymai is trying to do this just for visualization, it has nothing
to do about excel not being a "development tool" or more/less powerfull than
access, also each tool must be used for it's purpose/capabilities

sorry but to me your answer is not on the topic.