If you go to Cell A2, then go to the Window menu and choose Freeze Panes,
this will 'lock' Row 1 into place.
HTH Sheila
www.c-i-m-s.com
MS Office training - London
"pdgood" wrote:
If each column has a name (and these are in Row 1) is there any way to
keep these so that they view at the top of the page even if you scroll
down (in the same way that the A, B, C..... do now)?
For example, if you have Jan, Feb, March etc. in row 1 column A, B, C
etc. it is difficult to tell which month the contents of a cell in say
Row 50 belongs to once you scroll out of sight of the names of the
months.
Thanks.
--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=559906