making frames in a spread sheet?

J

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
 
G

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
 
S

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
 
Top