making frames in a spread sheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaymai108@gmail.com - 17 Nov 2006 00:14 GMT

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

Reply to this Message

Gord Dibben - 17 Nov 2006 00:23 GMT

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

>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
[quoted text clipped - 3 lines]
>thanks
>jay

Reply to this Message

zz - 20 Nov 2006 15:32 GMT

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.

> 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
[quoted text clipped - 3 lines]
> thanks
> jay

Reply to this Message

susiedba@hotmail.com - 20 Nov 2006 21:41 GMT

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

> window---split
>
[quoted text clipped - 8 lines]
> > thanks
> > jay

Reply to this Message

zz - 21 Nov 2006 00:48 GMT

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.

:=|

---
zz [MX]
cuasi-musico,semi-poeta y loco

> Excel ins't a software development tool; it's not as powerful as
> Access.
[quoted text clipped - 20 lines]
>> > thanks
>> > jay

Reply to this Message