Reversing freeze panes
Is there a way to use freeze panes to freeze the section to the RIGHT of the
selected cell instead of the area to the to the LEFT? |
Reversing freeze panes
No.
Why would you want that done? If you just want to limit the right-scrolling view, just hide the columns to the right of your data. Gord Dibben MS Excel MVP On Sun, 10 Aug 2008 09:34:01 -0700, axa wrote: Is there a way to use freeze panes to freeze the section to the RIGHT of the selected cell instead of the area to the to the LEFT? |
Reversing freeze panes
I want most of the sheet to be able to scrollwhile headings stay in view. I also have an area of cells that I don't want to be scrolled on the right hand side of the sheet "Gord Dibben" wrote: No. Why would you want that done? If you just want to limit the right-scrolling view, just hide the columns to the right of your data. Gord Dibben MS Excel MVP On Sun, 10 Aug 2008 09:34:01 -0700, axa wrote: Is there a way to use freeze panes to freeze the section to the RIGHT of the selected cell instead of the area to the to the LEFT? |
Reversing freeze panes
What you want is a left-side freeze and right-side freeze.
No can do as far as I know. You might be able to do something with a couple of vertical windows. WindowNew Window WindowArrangeVertical. Gord On Sun, 10 Aug 2008 12:48:01 -0700, axa wrote: I want most of the sheet to be able to scrollwhile headings stay in view. I also have an area of cells that I don't want to be scrolled on the right hand side of the sheet "Gord Dibben" wrote: No. Why would you want that done? If you just want to limit the right-scrolling view, just hide the columns to the right of your data. Gord Dibben MS Excel MVP On Sun, 10 Aug 2008 09:34:01 -0700, axa wrote: Is there a way to use freeze panes to freeze the section to the RIGHT of the selected cell instead of the area to the to the LEFT? |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com