![]() |
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. |
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. |
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. |
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. |
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