Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
I want to freeze the top three rows and left four columns of a workbook.
In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
Sean,
On the top Ribbon, click on Page Layout, then click on Print Titles. All you need is there. Bob Morris "Sean Nelson" wrote: I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
"robert morris" wrote:
On the top Ribbon, click on Page Layout, then click on Print Titles. All you need is there. That only affects printed output, not the screen window. From another post I discovered the secret: in order to freeze multiple rows and columns you need to select a BLOCK of cells rather than just one cell. With a BLOCK of cells selected, the View Tab's "Freeze Panes" drop-down list offers a "Freeze Panes" option instead of just "Freeze Top Row" and "Freeze First Column" options. The weird thing is that once you've discovered this and used it, the "Freeze Panes" option seems to always be available from that point on, even if you unfreeze the panes and select only a single cell, and even if you stop/restart Excel. Looks like some kind of bug to me... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007 - SeanNelso
Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps.
Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps.
Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps.
Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
I looked for this problem, but I could not find on the internet. And I have tried my own way. I sent the file to a friend, he froze the rows with excel 2003 and sent me back. That's all. :) Please tell me if this is possible with 2007.
On Thursday, January 15, 2009 6:40 PM SeanNelso wrote: I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? On Thursday, January 15, 2009 10:25 PM robertmorri wrote: Sean, On the top Ribbon, click on Page Layout, then click on Print Titles. All you need is there. Bob Morris "Sean Nelson" wrote: On Friday, January 23, 2009 2:40 AM SeanNelso wrote: "robert morris" wrote: That only affects printed output, not the screen window. From another post I discovered the secret: in order to freeze multiple rows and columns you need to select a BLOCK of cells rather than just one cell. With a BLOCK of cells selected, the View Tab's "Freeze Panes" drop-down list offers a "Freeze Panes" option instead of just "Freeze Top Row" and "Freeze First Column" options. The weird thing is that once you've discovered this and used it, the "Freeze Panes" option seems to always be available from that point on, even if you unfreeze the panes and select only a single cell, and even if you stop/restart Excel. Looks like some kind of bug to me... On Friday, September 25, 2009 9:07 AM Todd ODell wrote: Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps. Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still cannot get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx On Friday, September 25, 2009 9:09 AM Todd ODell wrote: Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps. Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still cannot get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx On Friday, September 25, 2009 9:10 AM Todd ODell wrote: Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps. Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still cannot get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze multiple rows/columns in Excel 2007
I'm surprised that you didn't find the answer when Googling for "Excel
2007" "freeze panes": http://www.google.co.uk/search?sourc...reeze+panes%22 As well as various third part answers, there are answers from Microsoft including: http://office.microsoft.com/en-us/ex...001217048.aspx David Biddulph On 06/10/2011 08:26, Yasin Mehdiyev wrote: I looked for this problem, but I could not find on the internet. And I have tried my own way. I sent the file to a friend, he froze the rows with excel 2003 and sent me back. That's all. :) Please tell me if this is possible with 2007. On Thursday, January 15, 2009 6:40 PM SeanNelso wrote: I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still can't get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? On Thursday, January 15, 2009 10:25 PM robertmorri wrote: Sean, On the top Ribbon, click on Page Layout, then click on Print Titles. All you need is there. Bob Morris "Sean Nelson" wrote: On Friday, January 23, 2009 2:40 AM SeanNelso wrote: "robert morris" wrote: That only affects printed output, not the screen window. From another post I discovered the secret: in order to freeze multiple rows and columns you need to select a BLOCK of cells rather than just one cell. With a BLOCK of cells selected, the View Tab's "Freeze Panes" drop-down list offers a "Freeze Panes" option instead of just "Freeze Top Row" and "Freeze First Column" options. The weird thing is that once you've discovered this and used it, the "Freeze Panes" option seems to always be available from that point on, even if you unfreeze the panes and select only a single cell, and even if you stop/restart Excel. Looks like some kind of bug to me... On Friday, September 25, 2009 9:07 AM Todd ODell wrote: Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps. Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still cannot get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx On Friday, September 25, 2009 9:09 AM Todd ODell wrote: Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps. Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still cannot get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx On Friday, September 25, 2009 9:10 AM Todd ODell wrote: Seems you can select a given column or row and click the Freeze Pane. I was able to just select a cell and then the Freeze Pane as well for the two axis. Hope this helps. Todd SeanNelso wrote: Freeze multiple rows/columns in Excel 2007 15-Jan-09 I want to freeze the top three rows and left four columns of a workbook. In Excel 2003 I could place the cursor at R4C5 and use "freeze panes" to do this. Workbooks created in this version display with the proper rows and columns frozen in Excel 2007. But in Excel 2007, I can only freeze the topmost row or the leftmost column using the "View" tab and the "Freeze Pane" drop-down button. What's worse, when I use "Freeze Top Row", any frozen columns are UNfrozen, and vice versa. I found a sneaky way to freeze multiple columns by hiding columns - for example to free the left four columns I hide columns A-C, freeze column D, then unhide columns A-C. But I still cannot get both multiple rows and columns frozen because when I free one the others unfreeze. What the heck am I missing? EggHeadCafe - Software Developer Portal of Choice WPF And The Model View View Model Pattern http://www.eggheadcafe.com/tutorials...l-view-vi.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze multiple columns | Excel Worksheet Functions | |||
Freezing multiple rows/columns in Excel 2007 Pro | Excel Worksheet Functions | |||
How to Freeze Multiple Rows/Columns | Excel Discussion (Misc queries) | |||
Freeze rows/columns in Excel | Excel Worksheet Functions | |||
Can I freeze multiple rows? | Excel Discussion (Misc queries) |