(Msg. 1) Posted: Wed Aug 20, 2008 12:59 am
Post subject: freeze multiple columns Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Is it possible to freeze one row (say, row A) and multiple columns (say,
columns 1, 2, 3, 9, & 15) where the frozen columns will stack under each
other as you scroll down the page? For instance, as I scroll down the page I
want column 9 to stop or freeze when it reaches column 3, and as I continue
to scroll down the page I want column 15 to stop or freeze at column 9. At
this point, columns 1, 2, 3, 9, & 15 would be stacked at the top of the page
and columns 16 through 23 are visible. Thank you.
(Msg. 2) Posted: Wed Aug 20, 2008 1:23 am
Post subject: Re: freeze multiple columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I think you are getting columns and rows mixed up, but I don't think
you can do what you want.
Pete
On Aug 20, 8:59 am, dmfw <d... DeleteThis @discussions.microsoft.com> wrote:
> Is it possible to freeze one row (say, row A) and multiple columns (say,
> columns 1, 2, 3, 9, & 15) where the frozen columns will stack under each
> other as you scroll down the page? For instance, as I scroll down the page I
> want column 9 to stop or freeze when it reaches column 3, and as I continue
> to scroll down the page I want column 15 to stop or freeze at column 9. At
> this point, columns 1, 2, 3, 9, & 15 would be stacked at the top of the page
> and columns 16 through 23 are visible. Thank you.
(Msg. 3) Posted: Wed Aug 20, 2008 1:36 am
Post subject: Re: freeze multiple columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Oops......I did have them mixed up. You think it is impossible?
"Pete_UK" wrote:
> I think you are getting columns and rows mixed up, but I don't think
> you can do what you want.
>
> Pete
>
> On Aug 20, 8:59 am, dmfw <d....TakeThisOut@discussions.microsoft.com> wrote:
> > Is it possible to freeze one row (say, row A) and multiple columns (say,
> > columns 1, 2, 3, 9, & 15) where the frozen columns will stack under each
> > other as you scroll down the page? For instance, as I scroll down the page I
> > want column 9 to stop or freeze when it reaches column 3, and as I continue
> > to scroll down the page I want column 15 to stop or freeze at column 9. At
> > this point, columns 1, 2, 3, 9, & 15 would be stacked at the top of the page
> > and columns 16 through 23 are visible. Thank you.
>
>
(Msg. 4) Posted: Wed Aug 20, 2008 1:38 pm
Post subject: Re: freeze multiple columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Yes. It is impossible
Gord Dibben MS Excel MVP
On Wed, 20 Aug 2008 01:36:01 -0700, dmfw <dmfw RemoveThis @discussions.microsoft.com>
wrote:
>Oops......I did have them mixed up. You think it is impossible?
>
>"Pete_UK" wrote:
>
>> I think you are getting columns and rows mixed up, but I don't think
>> you can do what you want.
>>
>> Pete
>>
>> On Aug 20, 8:59 am, dmfw <d... RemoveThis @discussions.microsoft.com> wrote:
>> > Is it possible to freeze one row (say, row A) and multiple columns (say,
>> > columns 1, 2, 3, 9, & 15) where the frozen columns will stack under each
>> > other as you scroll down the page? For instance, as I scroll down the page I
>> > want column 9 to stop or freeze when it reaches column 3, and as I continue
>> > to scroll down the page I want column 15 to stop or freeze at column 9. At
>> > this point, columns 1, 2, 3, 9, & 15 would be stacked at the top of the page
>> > and columns 16 through 23 are visible. Thank you.
>>
>>
(Msg. 5) Posted: Thu Aug 21, 2008 11:56 am
Post subject: Re: freeze multiple columns [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 20, 3:38 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Yes. It is impossible
>
> Gord Dibben MS Excel MVP
>
> On Wed, 20 Aug 2008 01:36:01 -0700, dmfw <d....RemoveThis@discussions.microsoft.com>
> wrote:
>
> >Oops......I did have them mixed up. You think it is impossible?
>
> >"Pete_UK" wrote:
>
> >> I think you are getting columns and rows mixed up, but I don't think
> >> you can do what you want.
>
> >> Pete
>
> >> On Aug 20, 8:59 am, dmfw <d....RemoveThis@discussions.microsoft.com> wrote:
> >> > Is it possible to freeze one row (say, row A) and multiple columns (say,
> >> > columns 1, 2, 3, 9, & 15) where the frozen columns will stack under each
> >> > other as you scroll down the page? For instance, as I scroll down the page I
> >> > want column 9 to stop or freeze when it reaches column 3, and as I continue
> >> > to scroll down the page I want column 15 to stop or freeze at column 9. At
> >> > this point, columns 1, 2, 3, 9, & 15 would be stacked at the top of the page
> >> > and columns 16 through 23 are visible. Thank you.
Well, you could open 2nd, 3rd, etc. windows of the same document and
then tile them. Each can be left at a different view.
In menu....Window:New Window
And to tile....Window:Arrange
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office