| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fix left column(s) and/or upper row
Great, thanks!
"Gord Dibben" wrote: Select a cell. Any rows above and columns left of that cell will be frozen when you Freeze Panes. B2 freezes row 1 and column A. Gord On Mon, 22 Jun 2009 00:11:01 -0700, mariekek5 wrote: Dear Gord, Thanks! Actually, I can freeze either the upper row or a column on the left....but not both... Is it possible to both freeze the upper row as well as a column on the left? Thanks in advance. Marieke "Gord Dibben" wrote: I think Luke meant "select C2 then WindowFreeze Panes" Gord Dibben MS Excel MVP On Fri, 19 Jun 2009 06:07:05 -0700, Luke M wrote: 1) Select column C, then go to Window - Freeze panes. 2) Select row 2, then go to Window - Freeze panes Freeze panes will always freeze to the left and/or above of your current selection.(if possible) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get rid of the left upper corner boxes with numbers | Excel Discussion (Misc queries) | |||
| I have arrowheads in upper left of some cells. How can I remove? | Excel Discussion (Misc queries) | |||
| grey dot in left upper corner of cell | Excel Discussion (Misc queries) | |||
| Upper Left Green sign | Excel Discussion (Misc queries) | |||
| How to change location A1 cell from upper right to upper left? | Excel Discussion (Misc queries) | |||
Hybrid Mode
