Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I freeze 3 different columns? | Excel Discussion (Misc queries) | |||
How to Freeze Multiple Rows/Columns | Excel Discussion (Misc queries) | |||
freeze other columns when columns have been frozen already | Excel Worksheet Functions | |||
Freeze Two Columns | Excel Worksheet Functions | |||
How do I freeze the widths of columns? | Excel Discussion (Misc queries) |