ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   freeze multiple columns (https://www.excelbanter.com/excel-worksheet-functions/199476-freeze-multiple-columns.html)

dmfw

freeze multiple columns
 
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.

Pete_UK

freeze multiple columns
 
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 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.



dmfw

freeze multiple columns
 
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 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.




Gord Dibben

freeze multiple columns
 
Yes. It is impossible


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 01:36:01 -0700, dmfw
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 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.





Spiky

freeze multiple columns
 
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
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 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 GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com