| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
freeze panes - freezes first 6 rows when only 1 required
I have made a spreadsheet using data copied from my Blue Cross Blue Shield
benefits website. When I try to freeze the top row (by selecting a cell, or the whole row), the first 6 rows are frozen. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
freeze panes - freezes first 6 rows when only 1 required
Mike
To freeze top row, select A2 and freeze panes. The rules are............everything above and left of the pre-selected cell will be frozen. If this is not happening for you, maybe the Blue Cross data came over with some merged cells. Check out FormatCellsAlignment and "Merge cells" setting. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 09:02:14 -0700, Mike wrote: I have made a spreadsheet using data copied from my Blue Cross Blue Shield benefits website. When I try to freeze the top row (by selecting a cell, or the whole row), the first 6 rows are frozen. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
freeze panes - freezes first 6 rows when only 1 required
Thanks for your speedy reply. Fixed!
"Gord Dibben" wrote: Mike To freeze top row, select A2 and freeze panes. The rules are............everything above and left of the pre-selected cell will be frozen. If this is not happening for you, maybe the Blue Cross data came over with some merged cells. Check out FormatCellsAlignment and "Merge cells" setting. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 09:02:14 -0700, Mike wrote: I have made a spreadsheet using data copied from my Blue Cross Blue Shield benefits website. When I try to freeze the top row (by selecting a cell, or the whole row), the first 6 rows are frozen. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| Freeze panes automatically freezes at r14 when I highlight r1? | Excel Discussion (Misc queries) | |||
| Freeze panes | Excel Discussion (Misc queries) | |||
| FREEZE PANES | Excel Discussion (Misc queries) | |||
| Freeze Pane command freezes more cells than I selected. | Excel Worksheet Functions | |||
Linear Mode
