View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default fix left column(s) and/or upper row


Unfreezeplace cursor where desiredfreeze
rows below cursor and columns to left will be frozen

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mariekek5" wrote in message
...
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)